Thanks Dave.

Yep, I thought of that. Tried it out.....no joy. Works fine on a new
sheet!!
I think the problem maybe the formula already in the cells where the times
are.


My head really hurts now :-(

Cheers Bob
"Dave Peterson" wrote in message
...
=sum(j12:j42)

give it a nice custom format of:
[hh]:mm:ss



Bob Holdford wrote:

.....can it!!

Column of cells
J12 to J42 inclusive.
Each cell has an amount of hours and minutes worked laid out like eg.
07:27 or 11:57

All I need to do is add the hours and minutes up!!! The answer is
looking
me in the face, and I can not see it!

HELP....please :-)

Best regards

Bob

--

Dave Peterson