How to show negative time (e.g. -10 hours)

A

Arhippa

How I'm able to calculate 5 hours 15 minutes minus 6 hours 30 minutes equals
-1 hour 15 minutes?
 
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.
 
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
 
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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate After hours 3
Hours and sum of hours 2
Time Calculation 3
Show time as a negative figure 3
problem with time subtraction 7
Excel: counting times and dates during non-traditional hours 0
pieces picked per hour 0
15 minute data to daily data 1

Top