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
|