| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Difference between times. Start time: 11:30PM End time: 5 AM
=(B1-A1) will work unless you pass through midnight
=(B1-A1)+(B1<A1) will correctly add 1 (one day, that is, 24 hours) when B1 appears to be before A1 (ie you passed through midnight) Try it with some of your data and tell me if you are happy with it best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Surrey" wrote in message ... I need to calculate the difference between times. The tricky part is that the start time is: 11:30PM and end time is: 5:00AM. Thanks for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate how much time falls between set start and stop times | Excel Worksheet Functions | |||
| find the difference between start time and end time when spanning. | Excel Discussion (Misc queries) | |||
| show time difference between start and end times | Excel Discussion (Misc queries) | |||
| Time difference between two times | Excel Worksheet Functions | |||
| HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES | Excel Worksheet Functions | |||
![Bernard Liengme[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
