Just checking..
you format it to 00:00:00

I hope you actually mean Time or hh:mm:ss in the Custom option

What do you see in the formula bar at the top when you click on one of
cells in your range?

Re-format that to Time (13:30:55 option)
Does this alter what appears in the cell and on the formula bar ?

Sigma on the total cell which then seems to want a range of cells put in.
of course it wants a range - it needs to know what you want to sum.

Usual set up of a worksheet, if you enter a column of numbers/times etc
then in a cell below these (not necessarily next to the bottom one)
Click on the cell, then the Sigma button
You should get =sum(B5:B15) or whatever your range is - and it should
automatically pick up the block of cells above the cell you are in.

if it doesn't do this then it doesn't think the cells are numeric

So back to the formatting again.

Steve





On Sat, 26 Aug 2006 17:54:44 +0100, B Bear
wrote:

No luck so far
-----
Think I just tried that??
And still 00:00
I'm formatting the cells to custom 00:00:00 then in the total box making
sure that is the same format.
Sigma on the total cell which then seems to want a range of cells put in.
Click the top cell and highlight down to the lowest puts the range in.
Enter and 0's.
:-(

-----------------