| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating difference between date/time fields
I am trying to count the difference between two fields which are date/time to
show if we met our service level agreements. However, I don't want to count non business hours. Business Hours are 8-5. For example Cell G3 is the date customer wants to close the deal - 6/23/2008 9:00 AM Cell I3 is actual closing date 6/23/2008 10:45 AM I would expect to see (1:45) Can anyone help? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difference of date/time only calculating workingdays/hours | Excel Worksheet Functions | |||
| calculating difference in time | Excel Discussion (Misc queries) | |||
| Daylight Saving Time (DST) and calculating time difference. | Excel Programming | |||
| Daylight Saving Time (DST) and calculating time difference. | Excel Programming | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
Threaded Mode
