+ Reply to Thread
Results 1 to 5 of 5

Adding hours and minutes..

  1. #1
    Avery Wagg
    Guest

    Adding hours and minutes..

    I'd like to add 10,311 hours and 20 minutes (10311:20), onto a calculated
    time (in minutes), but I can't figure out how to turn this large number into
    something excel can add time to.

    Any hints?

    ...Avery



  2. #2
    Forum Contributor
    Join Date
    06-10-2004
    Location
    India
    Posts
    1,066
    You cannot convert it to 10311:20 and expect excel toread it as time. You would need to manipulate it. You may simply treat it as 10311.20 and keep adding time to it, check the following link

    http://excelforum.com/showthread.php...highlight=time

    Mangesh

  3. #3
    Ron Rosenfeld
    Guest

    Re: Adding hours and minutes..

    On Fri, 10 Jun 2005 22:52:08 -0400, "Avery Wagg" <[email protected]> wrote:

    >I'd like to add 10,311 hours and 20 minutes (10311:20), onto a calculated
    >time (in minutes), but I can't figure out how to turn this large number into
    >something excel can add time to.
    >
    >Any hints?
    >
    >..Avery
    >


    You have a problem.

    The maximum time value that you can type into a cell is 9999:59:59. If you
    type a value that is greater than or equal to 10,000 hours (10000:00:00), the
    time appears as a text string.

    The maximum time value that you can calculate using a formula is
    71003183:59:59. This value equates to 12/31/9999 23:59:59, which is the maximum
    time that you can use, at least in Excel 2002.

    If you can operate within those constraints, perhaps by entering your large
    times as two smaller times, and then summing them, that would be one solution.

    Otherwise you will need to treat them as ordinary numbers and do the
    appropriate math.

    For example --

    A1: your calculated time
    A2: 9311:20
    A3: 1000:00
    A4: =SUM(A1:A3)

    Format the cells as [h]:mm


    --ron

  4. #4
    Peo Sjoblom
    Guest

    Re: Adding hours and minutes..

    1. You can't type 10311:20 in a cell without it becoming text, so just to
    enter that value you need to use

    =10311/24+"00:20"

    and format as [hh]:mm will return a time value of 10311:20
    then you can add time to it with a normal addition, assume you put that in
    A1 and in A2 you have
    00:40 (40 minutes)

    =A1+A2

    returns 10312:00




    --
    Regards,

    Peo Sjoblom

    (No private emails please)


    "Avery Wagg" <[email protected]> wrote in message
    news:[email protected]...
    > I'd like to add 10,311 hours and 20 minutes (10311:20), onto a calculated
    > time (in minutes), but I can't figure out how to turn this large number
    > into something excel can add time to.
    >
    > Any hints?
    >
    > ..Avery
    >



  5. #5
    Avery Wagg
    Guest

    Re: Adding hours and minutes..

    Hi Peo,

    Your solution works like a charm! Thanks ever so much. I can now automate
    my flight logs using Excel.

    ...Avery

    "Peo Sjoblom" <[email protected]> wrote in message
    news:[email protected]...
    > 1. You can't type 10311:20 in a cell without it becoming text, so just to
    > enter that value you need to use
    >
    > =10311/24+"00:20"
    >
    > and format as [hh]:mm will return a time value of 10311:20
    > then you can add time to it with a normal addition, assume you put that in
    > A1 and in A2 you have
    > 00:40 (40 minutes)
    >
    > =A1+A2
    >
    > returns 10312:00
    >
    >
    >
    >
    > --
    > Regards,
    >
    > Peo Sjoblom
    >
    > (No private emails please)
    >
    >
    > "Avery Wagg" <[email protected]> wrote in message
    > news:[email protected]...
    >> I'd like to add 10,311 hours and 20 minutes (10311:20), onto a calculated
    >> time (in minutes), but I can't figure out how to turn this large number
    >> into something excel can add time to.
    >>
    >> Any hints?
    >>
    >> ..Avery
    >>

    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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