negative times.

J

Jim 3975

I am comparing two times (mm:ss) by substraction, but Excel does not show
negative times. How do I solve this?
 
D

Dave Peterson

You can use
Tools|Options|Calculation tab|Check the 1904 date system.

Be aware that any existing date will be adjust by 4 years and one day.

And copying dates between workbooks with different date system settings will
have that same 4 years and 1 day change.
 

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

Geographical coordinates 3
Red cell for negative numbers in Excel 1
IF Logic Function with negative time or early time 1
How to sum negative times 2
Adding a negative number instead of substracting it 3
Minus Time Additions 5
DIsplaying negative time values 1
Times out of sequence 4

Top