Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting time going backwards past midnight?
I am trying to track time going backwards. In other words I am backing into a
start time. I am having problems when I cross midnight going backwards. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting time going backwards past midnight?
Try this:
A1 = 7:00 PM B1 = 3:00 AM =MOD(B1-A1,1) Format as h:mm = 8:00 Or, if you want the result in decimal format: =MOD(B1-A1,1)*24 Format as GENERAL or NUMBER = 8 -- Biff Microsoft Excel MVP "Billman" wrote in message ... I am trying to track time going backwards. In other words I am backing into a start time. I am having problems when I cross midnight going backwards. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting time going backwards past midnight?
You will have a problem there. Excel maintains times as fractions of 24
hours. To keep accurate time, you must also take date into account. as Excel maintains time and dates as date.time That is to say, the date is maintained as a whole number and the time as a fraction. Tyro "Billman" wrote in message ... I am trying to track time going backwards. In other words I am backing into a start time. I am having problems when I cross midnight going backwards. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting time going backwards past midnight?
=B1-A1+(A1B1)
Fomat cell as h:mm "Billman" wrote: I am trying to track time going backwards. In other words I am backing into a start time. I am having problems when I cross midnight going backwards. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time after midnight | Excel Worksheet Functions | |||
time around midnight | 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 |