A
Arhippa
How I'm able to calculate 5 hours 15 minutes minus 6 hours 30 minutes equals
-1 hour 15 minutes?
-1 hour 15 minutes?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
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.
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.
J
Jason Morin
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
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
A
Arhippa
Thanks a lot.
JE McGimpsey said: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.