| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Caluculate difference between two times
I am looking for a formula to calculate the difference between two times in
hours. I also want to exclude the time between 11 PM on Friday night and 11 PM on Sunday night. Example Time 2: 1/23/07 8:31 (B1) Time 1: 1/19/07 13:52 (A1) Difference is 90.7 hrs Excluding weekend hrs difference would be 42.7 hrs -- BRO |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference in two times over days | Excel Worksheet Functions | |||
| Calculate difference (mins) between 2 Times | Excel Worksheet Functions | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
| Difference in Times | Excel Discussion (Misc queries) | |||
| Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Threaded Mode
