Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a formula that will calculate the amount of time (in hours) that it
takes us to respond to a request, but i need hours of operations and not include weekends. Our hours of operations are 8am to 5pm. I have a submit date and time, and a respond date and time fields. Here are two examples: Submit field 11/26/08 4:00 pm Respond field 11/27/08 9:00 am Response time should be = 2 hours. Submit field: 11/26/08 6:00 pm Response field: 11/27/08 9:00 am Response time should be = 1 hour |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Elapsed Time | Excel Worksheet Functions | |||
Calculate Ending time using Start Time and Elapsed Time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) | |||
Need Elapsed Time Help | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) |