subtracting time, negative time

kidrobot

Registered User.
Local time
Today, 10:02
Joined
Apr 16, 2007
Messages
409
in excel if you subtract time and get a negative you will get the error... ##### "mic can't show negative times"

One way I found to fix this is change to the 1904 date system. Does anyone know of any other ways to do this because the 1904 date system doesn't give the correct DATE calculations. So if anyone has a macro or formula I could use, let me know!
 
In what circumstances does it give an incorrect calculation, assuming that the data is not shared or linked to another workbook using 1900.

brian
 
Brian, in 1900 when you subtract a time from another time and the sum is NEGATIVE Excel will not output anything but #####.

Try this is Excel.
A1////////B1
1:35 ////2:40

the subtract A1-B1
 
I know that , but it works for the Mac compatible 1904 date base, I thought that you were saying that using this gives Date calculation errors.

Brian
 

Users who are viewing this thread

Back
Top Bottom