Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Hi
also change your custom format to [hh]:mm -- Regards Frank Kabel Frankfurt, Germany schrieb im Newsbeitrag ups.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) | |||
Elapsed time Calc...over 30 days long... | Excel Discussion (Misc queries) |