+ Reply to Thread
Results 1 to 7 of 7

Adding Times

  1. #1
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Question Adding Times

    I need a formula please to add the following time values and get the shown result :

    19442:46 + 33:14 = 19476:00.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Adding Times

    A simple addition will do this.

    =A1+B1

    Use the same formatting on your result as for the first two numbers, which is probably [h]:mm.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Adding Times

    Excel regards time values of 10,000 hours or more as text values (although it can give you a valid calculation result > 10,000 hours), so you need to split the larger time in two or more time value < 10,000 hours, e.g.

    ="9999:00"+"9443:46" +"33:14"

    Put that in a cell, format as [h]:mm and you'll see 19476:00

    or you can do similar with the time values in cells, if you want it that way
    Audere est facere

  4. #4
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: Adding Times

    I did that already, unfortunately I got a #VALUE! as a result!

  5. #5
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Adding Times

    See my previous reply - you need to split up the times in to values less than 10,000 hours for Excel to recognise them as times

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Adding Times

    Quote Originally Posted by daddylonglegs View Post
    Excel regards time values of 10,000 hours or more as text values
    Dang, I never knew that

  7. #7
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Adding Times

    See Excel specifications and limits

    https://support.office.com/en-gb/art...rs=en-GB&ad=GB

    last entry in Calculation specifications and limits

    While other items have increased, e.g. number of nested functions allowed, Largest amount if time that can be entered has remained at 9999:59:59 for as long as I remember

+ 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. [SOLVED] adding times
    By peter renton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2013, 10:01 AM
  2. Adding times to times
    By jbnjr` in forum Excel General
    Replies: 2
    Last Post: 09-03-2011, 02:39 PM
  3. [SOLVED] Adding times
    By Jaime in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-11-2006, 12:30 PM
  4. [SOLVED] ADDING TIMES
    By John C. Harris, MPA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  5. [SOLVED] Adding times
    By Jim in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  6. ADDING TIMES
    By John C. Harris, MPA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  7. [SOLVED] Adding up Times
    By Lisa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. [SOLVED] Adding Times
    By Tony in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2005, 12:06 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