workday, networkday or something else?
Mike,
here is the field for Q838: 3/3/2010 4:06:08 PM
here is the field for T838: 3/3/2010 8:22:42 PM
This is my fuction
=((NETWORKDAYS(Q838,T838)-1)*("10:00"-"01:00")+MOD(T838,1)-MOD(Q838,1))*24
I would expect 4 hours 16 minutes and 34 seconds and change but what i get
is 16:06
"Mike H" wrote:
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?
|