negative times.


Jim 3975

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



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