Tracking running times
Manage your personal finances in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Tracking running times

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I need to be able to enter times that Excel will see as race times, not time of day. I need to go to the hundredths of seconds position and use them in a formula to calculate total and average. All I can find in the provided formats relate to time of day. I have thought of using different columns for each, minutes, seconds and hundredths, then using MODE (?) for the total of seconds to get the remainder to add to the minute column, but haven't worked on it yet, hoping Excel would have something built in. Any help?
    Thanks,


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try using a custom format such as [mm]:ss.00 (I'm asuming the races won't go into hours, if they do use [hh]:mm:ss.00). To enter a custom format, click on Format-Cells, select the Custom entry and type in the above.

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,864
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    On 2002-02-23 13:05, Mudface wrote:
    Try using a custom format such as [mm]:ss.00 (I'm asuming the races won't go into hours, if they do use [hh]:mm:ss.00). To enter a custom format, click on Format-Cells, select the Custom entry and type in the above.
    And use AVERAGE, SUM, MAX etc on the range formatted as Mudface suggests. Of course you need to apply the same custom formatting to cells where you do such calculations.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com