formating

[Steve Altheimer]

I am trying to create a spreadsheet that subtracts
one "stopwatch time" such as 2:33.29 (repersenting
minutes, seconds, and hundreths of a second)from another
similar number such as 2:34.78.

Whatever format I try, it just converts it to time of day
and does not give me the sum. (in this case 1.49 seconds)

Any suggestions?

Thanks.

 

[J.E. McGimpsey]

One way:


A1: 2:34.78
A2: 2:33.29
A3: =A1 - A2

All formatted using Format/Cells/Number/Custom mm:ss.00

 

[Steve Altheimer]

Thanks. That works, except when subtracting a larger time
from a smaller--it won't display a negative number. Any
ideas?

 

[J.E. McGimpsey]

The windows defaut 1900 date system won't display negative times. If
you choose Tools/Options/Calculation and check the 1904 date system
checkbox (macintosh default) your negative times will display fine.

Note however, that any dates already entered in your sheet will be
off by 4 years and 1 day.