Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Elapsed time Calc...over 30 days long... [email protected] Excel Discussion (Misc queries) 1 December 6th 04 06:39 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"