Results 1 to 9 of 9

Thread: timing (2000)

  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    timing (2000)

    I work often with timings of musical works. It would be great to be able to simply enter a series of timings, perhaps in a format such as 8:33 for 8 minutes and 33 seconds, and then have a function to add them for a total timing. However, Excel seems set up to handle inputs of "time of day" data but not "elapsed time" values. How do I do this?

    Joel

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: timing (2000)

    You can create custom time formats for elapsed time. For example, to display 1 hour, 23 minutes and 45 seconds as 83:45, use [mm]:ss. The square brackets around the minutes specify elapsed time instead of clock time. Similarly, to display 1 day, 2 hours and 3 minutes as 26:03, use [hh]:mm (if you use Dutch data/time settings, replace h with u).

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: timing (2000)

    If you enter 8:33 into a cell, Excel considers that to be 8 hours 33 minutes. You have to enter 0:8:33 to get 8 minutes 33 seconds. Then you have to format the cell as either [mm]:ss or [hh]:mm:ss to get elapsed time as Hans has already said.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: timing (2000)

    works like a charm, many thanks!

    Joel

  5. #5
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: timing (2000)

    The formatting suggestions worked great for individual timings (each denoting elapsed time). However, when I sum them, I get an answer that doesn't make sense. What do I need to do?

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: timing (2000)

    Could you give examples HOW it doesn't make sense? Perhaps post a sample workbook...

  7. #7
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: timing (2000)

    I've formatted all the timings cells to [mm]:ss. Some of the sums work and some don't.

    Joel

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: timing (2000)

    You have included the cells in row 8 in the sum formulas, for example =SUM(B8:B12). I think row 8 should be excluded, e.g. =SUM(B9:B12) etc.

  9. #9
    2 Star Lounger
    Join Date
    Jan 2003
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: timing (2000)

    Many thanks!

    Joel

Posting Permissions

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