Times are just numbers to Excel - it stores them as fractions of a 24-
hour day, so that 12:00:00 will be stored internally as 0.5, 6:00:00
(or 6 hours) as 0.25 etc. So, any of the normal arithmetic functions
SUM or + can be used with them. Perhaps you have entered the data as
text, so that it looks like a time but has no numeric value (so SUM
will give a result of zero).

Try formatting the cells as Number or General - if they are in Excel
time format you should see a load of fractional values, but if they
remain the same then they are really text values.

Hope this helps.

Pete

On Jun 26, 2:51*pm, chieflx wrote:
Hi Pete,
Thanks for the quick response, I have tried formatting the cell as [h]:mm:ss
or [hh]:mm:ss and using the formula =SUM(H10:H40) but still get 0:00
returned. I have also tried =H10+h11+h12... with no luck.

I am sure I must be missing something simple but have been staring at it so
long my mind is going blank :-).

Do you know of any other ways to add a list of times?
Cheers
Chieflx



"Pete_UK" wrote:
You should EITHER use the formula:

=SUM(H10:H40)

and apply the custom format [h]:mm:ss to the cell if you want to
display the result like that and keep the total in Excel time format,
OR if you use the formula:

=SUM(H10:H40)*24

this will convert the result into (decimal) hours, so you need to
apply the format of Number with, say, 2 dp. With this formula and
format, an answer of, say, 26 hours and 45 minutes will be displayed
as 26.75.

Hope this helps.

Pete

On Jun 26, 1:19 pm, chieflx wrote:
Hi,
I seem to be having the same problem as Fly Boy Five, I have a list of times
(the cells are custom formatted as hh:mm) and need to add them up to give me
a monthly total. I have followed the help in excel 2002 and used the formula
=Sum(H10:h40)*24 and formated the cell to hh:mm to give me a total in cell
h41 but it only returns as 00:00. After reading the posts on this thread I
have tried different formats on the total cell but can not seem to get it to
work.

Any help would be much appreciated.

Many thanks in advance
Chieflx

"Sandy Mann" wrote:
Fly Boy Five,

Simply use =SUM(A1:A21) and format the cell as Custom format [h]:mm

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk

"Fly Boy 5" wrote in message
...
I'm trying to add a column of hrs and minutes. *I tried to use the
=sum(a1:a21,"h:mm") *Don't work

What do you suggest?

Thanks Fly Boy Five

"Dave" wrote:

Hi,
I need to add up a list of hour and minutes, the only problem being is
that
Excel treats them as TIME not hours and minutes.

For example, if I sum 7:24, 7:24 , 7:24, 7:24 [ where 7 = hours and 24 =
minutes ] then Excel five me an answer of 05:36 rather than 29.36 - any
ideas
how I get this working ?

Thanks- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -