View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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)

....