Dave

Another way. Enter 0 in any cell (a unused cell). Copy the cell. Select the
range with the time in text Say A1:A30. Right clickPasteSpecial select
'Add' and OK. Now format to hh:mm:ss

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi

Thats great! This has solved the problem, however, is there not a way of
just converting the column to numeric format instead of having to put a new
column in?

Thanks for your help

"Jacob Skaria" wrote:

Look like the data is in text format. Insert a column to the right such as if
Col A is having the current data; and in B1 enter formula =A1*1 and copy that
down as required. Format ColB to time hh:mm:ss. and then do the sum with
[h]:mm:ss


If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi, This doesnt seem to work. There seems to be a problem with the formatting
of the cells that I am trying to sum. They display the duration as 0:00:10 if
I click into them indivdually they change to 00:00:00 and excel is able to
sum them however, this is not a solution as there are over a thousand.

I have tried formatiing the entire column but this does not work. There is
nothing to say that this is an error with the formatting of the cell and to
convert it.

What is the solution to this?

Thanks

"Jacob Skaria" wrote:

Dave , do the normal sum itself; but format the total cell to [h]:mm:ss

Right clickFormat CellsCustom

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi, does anyone know how this is possible?

Thanks