To get hours you can use this technique
http://www.cpearson.com/excel/DateTimeWS.htm
Regards,
Peo Sjoblom
"Lichase" wrote:
IF(C11=W11,IF(T11="",NETWORKDAYS(R11,S11),NETWORKD AYS(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.