+ Reply to Thread
Results 1 to 3 of 3

Hour Sum

  1. #1
    Registered User
    Join Date
    11-10-2005
    Posts
    8

    Hour Sum

    Hello,

    How is it possible to make a sum of hours?
    I just the format 09:45 and wanted to sum several cells. The result is, that after 24 hours the sum starts at 0 again.
    Which kind of formula could I use for the sum of hours?

    Thanks a lot
    Vicky

  2. #2
    Bernard Liengme
    Guest

    Re: Hour Sum

    Format the cell with [h]:ss
    The square brackets prevent mod 24 arithmetic
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "Vic1978" <Vic1978.1yabjb_1131632412.0378@excelforum-nospam.com> wrote in
    message news:Vic1978.1yabjb_1131632412.0378@excelforum-nospam.com...
    >
    > Hello,
    >
    > How is it possible to make a sum of hours?
    > I just the format 09:45 and wanted to sum several cells. The result is,
    > that after 24 hours the sum starts at 0 again.
    > Which kind of formula could I use for the sum of hours?
    >
    > Thanks a lot
    > Vicky
    >
    >
    > --
    > Vic1978
    > ------------------------------------------------------------------------
    > Vic1978's Profile:
    > http://www.excelforum.com/member.php...o&userid=28708
    > View this thread: http://www.excelforum.com/showthread...hreadid=483899
    >




  3. #3
    Ron Rosenfeld
    Guest

    Re: Hour Sum

    On Thu, 10 Nov 2005 08:18:38 -0600, Vic1978
    <Vic1978.1yabjb_1131632412.0378@excelforum-nospam.com> wrote:

    >
    >Hello,
    >
    >How is it possible to make a sum of hours?
    >I just the format 09:45 and wanted to sum several cells. The result is,
    >that after 24 hours the sum starts at 0 again.
    >Which kind of formula could I use for the sum of hours?
    >
    >Thanks a lot
    >Vicky


    Same formula. But to keep the hours display from "rolling over" at 24, format
    the cell where you have your SUM formula as [h]:mm The brackets keep the 24 hr
    hour rollover from occurring.


    --ron

+ 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