Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Average minutes and seconds!

  1. #1
    Guest

    Default

    I'm stumped!

    I need to average race times by mile segment by day. We use minutes and seconds. I have each in it's own column. So column A is a date, column B is Mile 1 minutes and column C is mile 1 seconds, etc.

    When I try to get avgs I end up with al sorts of stuff, none of which is useful!

    I would like to get a running avg and a monthly avg.

    Any tips! PLEASE!

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-02 15:09, Anonymous wrote:
    I'm stumped!

    I need to average race times by mile segment by day. We use minutes and seconds. I have each in it's own column. So column A is a date, column B is Mile 1 minutes and column C is mile 1 seconds, etc.

    When I try to get avgs I end up with al sorts of stuff, none of which is useful!

    I would like to get a running avg and a monthly avg.

    Any tips! PLEASE!
    Why not have format column B as [m]:ss and then put in your times in column B only? You can then perform averages on that column. If you need any help on this just let me know.

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

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
  •