Counting DD:HH:MM NETWORKDAYS and Hours
I think you may need to look again at the syntax of the WORKDAY() function.
Why are you adding B23 working days to your B23 start date?
--
David Biddulph
"Oliver L Randle" wrote in
message .. .
....
I notice that you have managed to get Excel to recognise 3/4 within
networkdays as 18:00 hrs but I have tried the same thing with WORKDAY
but it will not see it in the same way.
I have tried:
=IF(WORKDAY(B23,B23)3/4,(B23+1),B23)
-to no avail. (I have separated out days and hours again to facilitate
multiple 'on hold' times)
....
|