J Jim 3975 Jun 9, 2007 #1 I am comparing two times (mm:ss) by substraction, but Excel does not show negative times. How do I solve this?
I am comparing two times (mm:ss) by substraction, but Excel does not show negative times. How do I solve this?
D Dave Peterson Jun 9, 2007 #2 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.
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.
