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?
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 [email protected]> wrote in message
news:[email protected]...
> 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 [email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks