Thread
:
Elapsed time Calc...over 30 days long...
View Single Post
#
2
Frank Kabel
Posts: n/a
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!
Reply With Quote