On Fri, 23 Oct 2009 06:17:01 -0700, Sam J <Sam
wrote:

Depending on what version of excel you have could you not just change the
format of the cell so it only displays hours, minutes, seconds

Format cells
Numbers Tab
Custom
and either go down the list until you find hh:mm:ss
or you could just type that in.

This way if you hi-light the whole column all the cells will be changed at
once as well.

Hope this helps

Sam,

That process will only change what is displayed. It will NOT change what is
stored. And any math performed on the data will act on the value stored, and
this may lead to unexpected results.

Consider the following

Format A1:A3 as h:mm:ss

then enter

A1: 4:33:07.4
A2: 4:33:07.4
A3: =A1+A2

The cells will display:

4:33:07
4:33:07
9:06:15


whereas you would probably want A3 to display

9:06:14
--ron