Time measurements fromulas?

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?

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)


"Todd W." <Todd W.@discussions.microsoft.com> wrote in message
news:D94C7A69-3D3D-4BEB-9875-B604C8995128@microsoft.com...
> 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?

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.

--
Regards,
Fred


"Todd W." <Todd W.@discussions.microsoft.com> wrote in message
news:D94C7A69-3D3D-4BEB-9875-B604C8995128@microsoft.com...
>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?