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.
 
Top