Try something like

=SUM(--G1:G10)

--
__________________________________
HTH

Bob

"Chris waller" wrote in message
...
I have been helping a colleague with an Excel problem and to be honest it
has
got me stumped. My colleague is downloading a report from one system into
an
Excel spreadsheet. A number of the columns contain time in the format
hh:mm:ss, however if you try to use the autosum or the = sum formula on
them
and subsequently format the answer cell it shows 00:00:00, however if you
go
into each cell edit (F2) and then press enter, it then includes the
figures
in the total. As this could be a very laborious job depending how many
cells
there are, I was wondering if anyone knew what was causing the problem and
a
possible answer. I do have an abridged version of the file with me, so if
anyone needs to look at it, I could post to a convenient place. TIA