|
| 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
December 11th, 2008, 04:00 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
time elapsed
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
