+ Reply to Thread
Results 1 to 3 of 3

Time measurements fromulas?

  1. #1
    Todd W.
    Guest

    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?

  2. #2
    Bob Phillips
    Guest

    Re: Time measurements fromulas?

    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?




  3. #3
    Fred Smith
    Guest

    Re: Time measurements fromulas?

    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?




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1