That doesn't work for me. I'm using the help file's SUM(A2:A6)*24 because
it's more than 24 hours. I'm adding:

4:05
7:00
1:20
6:45
4:30
1:05
1:55
5:15
0:15
1:45
3:20
0:35

and I'm getting 20:00 as the result, which is obviously wrong. Why does the
summation not work?

"Peo Sjoblom" wrote:

It's correct, it is whomever entered times as :mm:ss (leading colon) that
made a mistake. Excel interprets this as text, so change the :42:39 to
0:42:39 and all the other entries that were made like that the same way and
you should get what you expect


--
Regards,

Peo Sjoblom



"Barbara W" wrote in message
...
Thanx for the quick response. However, I tried using that format and it is
not adding up.

Here's what is happening:

1:03:06
:42:39
1:07:10
:55:54
:09:49
1:17:18
The sum is 3:27:34
--
which is incorrect it should be 5:15:56.

Please respond...
Barbara W


"Piscator" wrote:

You didn't say what was appearing but yes, you probably need to format
the total cell.
Format, Cell, Number, Time and select the most appropriate. Mine has
a 37:30:55 option which should be OK for you.