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