| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula to calculate elapsed time between certain dates and times
Hi
I am trying to calculate the elspased time between certain dates and times with a result in total hours. The catch is that I only want the formula to inlcude times during business hours (Monday to Friday, 8:30am - 5:30pm) E.g (17/12/2004 10:07) - (3/02/2005 15:22) = ??? Is this possible with excel? Many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate time difference to the half hour | Excel Worksheet Functions | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
| Formula to calculate only the negative numbers | Excel Worksheet Functions | |||
Threaded Mode
