NETWORKDAYS FORMULA  
Author Message
harpers11





PostPosted: Thu Jun 09 15:24:07 CDT 2005 Top

worksheet functions >> NETWORKDAYS FORMULA

IF(C11=W11,IF(T11="",NETWORKDAYS(R11,S11),NETWORKDAYS(R11,T11)),NETWORKDAYS(R11,S11))

When I use the networkdays function as above, it's returning multiples of
24. It rounds up to the next multiple. I need it to return the number of
hours elapsed. Please help.

Also, how do I account for the holidays not worked?

Thanks.

Excel395  
 
 
PeoSjoblom





PostPosted: Thu Jun 09 15:24:07 CDT 2005 Top

worksheet functions >> NETWORKDAYS FORMULA To get hours you can use this technique


http://www.cpearson.com/excel/DateTimeWS.htm


Regards,

Peo Sjoblom




> IF(C11=W11,IF(T11="",NETWORKDAYS(R11,S11),NETWORKDAYS(R11,T11)),NETWORKDAYS(R11,S11))
>
> When I use the networkdays function as above, it's returning multiples of
> 24. It rounds up to the next multiple. I need it to return the number of
> hours elapsed. Please help.
>
> Also, how do I account for the holidays not worked?
>
> Thanks.