its very simple, yet i can't figure it out!...(excel formula

[Umar B]

Hi

Im having real trouble trying to remember how to do a simple task in MS excel,

all i have to do is to total up a set of call duration times, ie

21:32
29:32
61:02
10:43
0:10
0:45

Its format is mintues and seconds, i just need to add up those call times to get a total call duration time

im sure its simple, but i don't seem to get it.

any idea people?

thanks

[Plotloss]

If you convert the durations to the HH:MM:SS format (with colons) =sum works perfectly.

So in your example

00:21:32
00:29:32
01:01:02
00:10:43
00:00:10
00:00:45

Produces a result using =sum of 02:03:44

[mmertens]

Set the column containing your times to custom format [h]:mm, and then just use the sum function to add them up. This prevents 24hr wraparound when the total is more than 24 hours.

Edited by mmertens on Wednesday 11th April 11:58

[Plotloss]

Or follow mmertens far easier suggestion

[Miles_stylus]

Use the custom format [h]:mm:ss and the normal sum function.

Miles

[Umar B]

THANKS YOU ALL VERY VERY MUCH!!!

both methods works a treat, and now my memeory banks have burst open too.

This prove 2 things:

1. the power of PH is unquestionable and;
2. i need to eat more oily fish to improve my memory

thanks again

Umar