..3611 is the correct time serial..
you only need to format the new column to display the number as time.








--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Carol Wolfe wrote :

That didn't seem to work, here's a sample of what happened:

840 0.361111111
1213


I copied your formula into the cell in my temporary column

"keepITcool" wrote:


Carol
if i read you correctly you need timeserials

add a temporary column..

if the last 2 digits are seconds then
with formula =TIMEVALUE(TEXT(B1,"00\:00\:00"))
if they are minutes then
with formula =TIMEVALUE(TEXT(B1,"00\:00"))

dragdown.. then copy /pastespecial values..





--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Carol Wolfe wrote :

I have a column of 3 and 4 digit numbers. I would like to insert
a colon : to the immediate left of the 2 numbers on the far
right of the cell. Is there a way to do this easily?