+ Reply to Thread
Results 1 to 4 of 4

Adding time that exceeds 24 hours

  1. #1
    Forum Contributor
    Join Date
    10-31-2006
    Location
    Oslo, Norway
    MS-Off Ver
    MS 365 Business
    Posts
    286

    Adding time that exceeds 24 hours

    Adding hours and minutes that exceeds 24 hours gives unexpected result.

    [h]:mm;@ described at the Excel-help-pages, doesnt work.
    Any solution?
    Attached Files Attached Files

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

    Re: Adding time that exceeds 24 hours

    You haven't applied that Custom Format to the cell. The square brackets around the h stops the time from wrapping at 24 hours, so it will display 27:30 with that custom format, instead of 3:30.

    Hope this helps.

    Pete

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,686

    Re: Adding time that exceeds 24 hours

    i change the format in the cell
    to
    custom
    [H]:mm:ss

    and got the correct answer

    The format in the sheet was set to
    time

    right click on the cell
    format
    change to
    custom
    choose

    [H]:mm:ss
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Adding time that exceeds 24 hours

    you can use below formula
    =TEXT(SUM(C2:C4),"[HH]:MM")+0


    or set the formatting as [HH]:MM
    Last edited by hemesh; 01-31-2016 at 09:11 AM.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

+ 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. Payroll time sheet calculation where time exceeds 24 hours
    By Rolo1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2014, 08:57 AM
  2. [SOLVED] Adding hours to start time - Business hours/holidays/weekends
    By Thunderer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 01:09 PM
  3. Adding time (more than 24 hours) to date time stamp
    By sidapt in forum Excel General
    Replies: 6
    Last Post: 01-06-2014, 04:08 AM
  4. From an AM time to an AM time, exceeds 24 hours. How to calculate?
    By bodycode in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-26-2013, 03:56 AM
  5. Trouble pulling out hours when sum exceeds 24 hrs
    By Steelman in forum Excel General
    Replies: 8
    Last Post: 07-08-2009, 07:48 PM
  6. How do I summarize time that exceeds 24 hours?
    By Rose in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-02-2006, 05:30 PM
  7. [SOLVED] Can I get Excel to calculate hours:minutes when sum exceeds 24?
    By nickq2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-17-2006, 10:15 AM

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