formating


S

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

Advertisements

J

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
 
S

Steve Altheimer

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

Advertisements

J

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.
 

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

Top