Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculations from date and time values | Excel Worksheet Functions | |||
Need help: convert seconds to date and time | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel |