No. Still comes up with 0's.
When I go back to format it shows it as being in time format even though I
set [h]:mm:ss.
calm calm calm!

"kassie" wrote in message
...
No need to get annoyed! If you format as hh:mm:ss, you will be stuck in a
24
hour loop. If you now add 08:30:00, 09:30:00 and 08:00, you will get a
total
of 02:00:00. If you format as [h]:mm:ss, you will get 26:00:00. There's
a
load of difference between formatting as 00:00:00, hh:mm:ss and [h]:mm:ss

"B Bear" wrote:

Getting annoyed now!!!
Now where's my base 60 calculator?


"B Bear" wrote in message
...
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.
:-(

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