Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Summing times

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a list of times:
    8:05
    8:05
    8:05
    8:05
    5:40

    When I sum these it comes back with 14, but it should be 38.

    Please help!

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Change the format of the summation cell to Custom> [h]:mm:ss

  3. #3
    Board Regular s-o-s's Avatar
    Join Date
    Apr 2002
    Location
    Kissimmee, Florida
    Posts
    384
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Excel has calculated 38 but it shows the time formating being 38-24hrs = 14

    If you have another cell which = then sum of your times *24 It will give you 38. Excel treats Times as a fraction of a day.

    To see reformat your dates as numbers and they will all show as 0.33 approx.
    Hope This Helps.
    Sean.
    Digest of Homes

    WinXP, XL XP

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
  •