Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to show negative time (e.g. -10 hours)
How I'm able to calculate 5 hours 15 minutes minus 6 hours 30 minutes equals
-1 hour 15 minutes? |
#2
|
|||
|
|||
One way:
Change your workbook's date system to the 1904 system (Tools/Options/Calculate, check the 1904 date system checkbox). The WinXL default 1900 system can't display negative time values. In article , "Arhippa" wrote: How I'm able to calculate 5 hours 15 minutes minus 6 hours 30 minutes equals -1 hour 15 minutes? |
#3
|
|||
|
|||
Another option is to display the negative time value as a
text value in another cell while still using the actual difference (#######) in any calculations. =IF(B1=A1,TEXT(B1-A1,"[h]:mm:ss"),TEXT(A1-B1,"- [h]:mm:ss")) HTH Jason Atlanta, GA -----Original Message----- How I'm able to calculate 5 hours 15 minutes minus 6 hours 30 minutes equals -1 hour 15 minutes? . |
#4
|
|||
|
|||
Thanks a lot.
"JE McGimpsey" wrote: One way: Change your workbook's date system to the 1904 system (Tools/Options/Calculate, check the 1904 date system checkbox). The WinXL default 1900 system can't display negative time values. In article , "Arhippa" wrote: How I'm able to calculate 5 hours 15 minutes minus 6 hours 30 minutes equals -1 hour 15 minutes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
in excel totaling weekly hours military time | Excel Worksheet Functions | |||
time format multiplied by hours worked ? | Excel Worksheet Functions | |||
negative time | Excel Discussion (Misc queries) | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |