Elapsed time Calc...over 30 days long...
 

B2 C2 D2
09/29/04 9:59 AM 11/30/04 05:23 PM 2 Days 08 Hours 02
Minutes

D2's formula is C2-B2.
D2's custom format is d "Days" hh "Hours" mm "Minutes"

I'd like this to correctly calculate. Later, I'd like to calculate
based on work hours (8am until 6pm), take out weekends and holidays.
I've tried to use Networkdays, but it has not come out correctly yet.
You can email me at SeanRinVA at gmail dot com

Thanks!

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

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
B2 C2 D2
09/29/04 9:59 AM 11/30/04 05:23 PM 2 Days 08 Hours 02
Minutes

D2's formula is C2-B2.
D2's custom format is d "Days" hh "Hours" mm "Minutes"

I'd like this to correctly calculate. Later, I'd like to calculate
based on work hours (8am until 6pm), take out weekends and holidays.
I've tried to use Networkdays, but it has not come out correctly yet.
You can email me at SeanRinVA at gmail dot com

Thanks!