Bob,

Using your formula, I put my numbers in column B (and what you told me to
put in column C)

10:10:00 in cell B1 - this is HH:MM:SS of ALL calls (total time of all calls)

10 in cell B2 - this is how many calls were taken,

So 10:10:00 (10 hours and 10 mins), divided by ten calls gives you an
average of 01:01:00 (1 hour and 1 min per call). Obviously my figures will be
more complicated than this in the real thing.

It will be me - not very gopod with Excel.

Thank you for your help.
--
Rob,
Teesside,
UK


"Bob Phillips" wrote:

Rob,

Are you saying that B 1 is a call time, and B2 is an other call time? If so,
why is B2 not in time, and why is the answer 1:01:00?

--
HTH

Bob Phillips

"abfabrob" wrote in message
...
Hey there,

Thanks you for the help, but can't get it to work... E.G.

B1: 10:10:00 (HH:MM:SS)
B2: 10

Your formula states answer as 05:05, when it should be 01:01:00

???
--
Rob,
Teesside,
UK


"Bob Phillips" wrote:

Assume the times are in column B

C1: = SUM(b:B) and format as [hh]:mm
C2: =AVERAGE(B:B)

--
HTH

Bob Phillips

"abfabrob" wrote in message
...
I want to create a spreadsheet that will automatically calculate a
sum...
I
have no idea how to do this...

My Telephone section took 1563 calls.

All these calls added together took 80:39:43 (HH:MM:SS)

Is there any way I can get staff to enter these numbers in to Excel to
work
out the AVERAGE call length in MINUTES?

Any help is much appriciated, though I am virtually clueless when it
comes
to Excel.

Thank you,

--
Rob,
Teesside,
UK