Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate Time during different sets of work hours
I am trying to calculate the total time it takes to resolve an issue
within an organization that has a 24 x 5 work schedule during the week and 9-5 hours on the weekend. I want to make sure that the non-work hours on the weekend are not calculated. Does anyone have a formula for the example below? Submitted Date Resolved Date 10/15/08 10:51:20 AM 10/25/08 02:54:32 PM Thanks in advance, LJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate WORK-hours between end/start date | Excel Discussion (Misc queries) | |||
UDF To Calculate Work hours between two dates Problem with code | Excel Discussion (Misc queries) | |||
How do you subtract time as in a timecard to calculate hours work | Excel Worksheet Functions | |||
calculate hours on work sheet | Excel Worksheet Functions | |||
Calculate work hours between two dates | Excel Worksheet Functions |