+ Reply to Thread
Results 1 to 5 of 5

How to sum time (HH:MM:SS)

  1. #1
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    How to sum time (HH:MM:SS)

    Hi, I'm facing problem summing time. Not sure how to handle it.
    Capture.PNG

    Thanks
    Thomas
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: How to sum time (HH:MM:SS)

    Format the total cell as [h]:mm:ss ... note the square brackets round the h.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: How to sum time (HH:MM:SS)

    You need to apply a Custom Format in cell C5 of:

    [h]:mm:ss

    to prevent the hours from wrapping at 24. This is the English version, but in Denmark you will need to use the initials for hours, minutes and seconds - the important bit is to put square brackets around the hours term.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    05-25-2020
    Location
    Denmark
    MS-Off Ver
    Professional Plus 2016
    Posts
    58

    Re: How to sum time (HH:MM:SS)

    Thanks both. Works perfectly!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: How to sum time (HH:MM:SS)

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 9
    Last Post: 10-16-2020, 04:25 PM
  2. Replies: 5
    Last Post: 05-09-2018, 12:30 PM
  3. [SOLVED] time sheet help, format TIME and formula based on the actual time entered.
    By bh mng in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-06-2016, 01:10 PM
  4. Replies: 0
    Last Post: 03-04-2016, 06:38 PM
  5. Replies: 10
    Last Post: 11-08-2014, 04:51 PM
  6. Replies: 5
    Last Post: 04-18-2013, 11:31 AM
  7. Replies: 3
    Last Post: 11-06-2012, 01:37 AM

Tags for this Thread

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