workday, networkday or something else?
Hi,
Try this.
the formula 'assumes' that you won't take/close any orders outside of the
workday. i.e. if you working days starts at 08:00 you won't take an order at
07:00 on that day.
Holidays is a named range of any holiday dates to exclude
=((NETWORKDAYS(Q1,T1,Holidays)-1)*("16:00"-"08:00")+MOD(T1,1)-MOD(Q1,1))*24
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"AJ" wrote:
I have two date and time fields, the Q column is the Ordered Date and the T
colum is the Date Closed. We work 8 hours a day from 8-5. Im trying to
figure out how many hours / minutes it took someone to do the work from the
time it went ordered to the point it closed. Taking into account our work
day, which function should i use one of the ones i listed or other ones?
|