Time measurements fromulas?

T

Todd W.

I need to measure the difference in times for swimming. I am having a
difficult time in getting a formula to read column A & B and measuring the
difference in mm:ss.00. Can anyone help?
 
B

Bob Phillips

Simply take one form the other to get the difference, it is just numbers.
Format the result cell as mm:ss.00

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
F

Fred Smith

What's in column A and B? If the data is in time format (eg, mm:ss), you just
subtract one from the other (=b1-a1). If your data is in some other format, let
us know and we'll show you how to convert it.
 
Top