I'm beginning to wonder if you are getting sums of times (in time format) and
haven't converted them to hours by multiplying the sum by 24.
--
HTH,
Barb Reinhardt



"Randy Rich" wrote:

I get a column of TRUE every time I test.
--
Thanks, Randy


"Barb Reinhardt" wrote:

It's possible that you are trying to sum things that aren't numbers. In an
adjacent column, put something like this to test

=ISNUMBER(A1)
--
HTH,
Barb Reinhardt



"Randy Rich" wrote:

I am struggling to get a column of talk times from our call center to total
up. The format is 0:00:05, for example, and represents the output from the
phone equipment. The report shows the agent name, and the total talk time.
I'm interested in getting a total off all the time all the agents spent on
the phone, and I'm stumped. It just won't =sum(b2:b248). It will do
=b2+b3+b4, but that is going to be difficult when the report is several
thousand entries long. I can use a different column, and get running totals,
but I am puzzled why I can't just get a total from the column. Does anyone
have any insight into the workings of Excel 2007?
--
Thanks, Randy