| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
time clock wrap around midnight
Hi
For example I have two times entered as 23:30 and 1:45 (but the next day) we are not entering the date just the time. Subtracting the two gets the correct answer but when the times wrap around midnight (as above) then there is a negative time difference and it is wrong. How can I keep entering just the basic time (without date) and take the difference and make this difference work around midnight? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change EXCEL Clock to Standard Clock or Military Time | Excel Worksheet Functions | |||
| Calculating time past midnight. | Excel Discussion (Misc queries) | |||
| subtraction off time after midnight | Excel Worksheet Functions | |||
| Calculating Time Past Midnight | Excel Worksheet Functions | |||
| Calculating time interval (some across midnight) | Excel Worksheet Functions | |||
Threaded Mode
