Make sure the Anaylsis ToolPak Add-in is activated (Tools-addins)

=NETWORKDAYS(B29,C29)-1&" days "&INT(MOD(C29-B29,1)*24)&" hours
"&INT(MOD((C29-B29)*24,1)*60)&" minutes"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"tech1NJ" wrote:

I have a problem displaying the time (minutes) correctly beyond 60 minutes.
Fox example:

B29 = 3/17/09 4:10 PM - cell formated as DATE and TYPE 3/17/09 4:10 PM
C29 = 3/19/09 10:05 PM - cell formated as DATE and TYPE 3/19/09 10:05 PM
D29 will display 24 hours 1075 minutes.
Formula in D29 =INT(C29-B29)*24& "hours "&INT(MOD((C29-B29),1) & minutes"

2 things that I would like to have display in D29
a) is X days X hours X minutes.
b) Total time to exclude the weekends as it is not a business day for us.
I know that I'm mssing something here but do not know what exactly. Can
anyone help.
--
tech1NJ