W
watermt
=IF(OR(D41="",F41=""),0,(NETWORKDAYS(D41,F41)-1)*("15:00"-"06:30")+MOD(F41,1)-MOD(D41,1))
I’m trying to calculate the non-working time accumulated by a process
outside the normal shift of M-F 0630-1500 timeframe. But if all the work is
done on a non-working day (Saturday or Sunday) I get the negative dates or
time symbol ########, or in some cases hours after or before the time above
for M-F. I’ve checked the dates and they’re correct.
Can someone explain possibly other reasons why this may be occurring?
Mike
I’m trying to calculate the non-working time accumulated by a process
outside the normal shift of M-F 0630-1500 timeframe. But if all the work is
done on a non-working day (Saturday or Sunday) I get the negative dates or
time symbol ########, or in some cases hours after or before the time above
for M-F. I’ve checked the dates and they’re correct.
Can someone explain possibly other reasons why this may be occurring?
Mike