If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can this even be done? Tracking Date / Time Elapsed
I'm trying to create a worksheet which records elapsed time between Date /
Time Received and Date / Time Delivered. So far, so good. Problem is, the elapsed time I get really needs to use some form of Networkdays, excluding Holidays, and (here's the really tricky part) non-work hours. I've tried fiddling with various Ifs, but am not experienced enough at Excel to grasp why my formulas don't work. What I currently have is giving me total time elapsed, which is good: Received (A1) - 12/30/05 16:08 Delivered (B1) - 1/3/06 9:20 Elapsed (C1) - =(A1-B1) 3:17:12 (formatted Custom - d:h:mm) The result I actually want in this example is 0:2:12, based on 52 elapsed minutes on 12/30/05 and 1:20 on 1/3/06 (clock stops between 5PM & 8AM), excluding weekends, holiday (1/2/03) & overnight hours (17:00-08:00). Is there any *possible* way to get there from here? Any help greatly appreciated, but as I said, I'm not all that Excel savvy, so type... real... slow... |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Do when a time and date has elapsed | Michael | General Discussion | 3 | April 24th, 2005 10:46 PM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Seemingly (and probably) complex turnaround time | rgrantz | Running & Setting Up Queries | 1 | March 21st, 2005 09:19 AM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |