When I leave the cells blank - A1: 00:00:00 and A2: 0, A3 displays: "#DIV/0!"
(but without the qutation marks. Why is this? I want it to be all zeros so
that users can enter their own numbers...
Thanks for your help.
--
Rob,
Teesside,
UK
"Bart Snel" wrote:
I don't see the problem. When I put 10:10:00 in A1 (formatted hh:mm:ss) and
10 in B1,
the formula A1/B1 gives me 1:01:00...
"abfabrob" schreef in bericht
...
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
|