Assume your data starts in row 2, so put this in E2:

=D2/60/60/24

and then apply a custom format to the cell of:

[m]:ss.00

Then copy the formula down as required.

Hope this helps.

Pete

pauls56;297293 Wrote:
Hi, I am working on a spead sheet that in D colum has 76.50 this
represents
76 seconds and .50 100's of a second
I am tring to come up wit a formula that will convert this to 1:06.50
in the
next colum E.
Colum D has appox. 68 cells all with various times in them like 143.89
again
this ia seconds and iooth of a second which should convert to 2:23.89
2min:23sec.and .89 one hunderths of a sec. Im stumped :)

Thanks PaulS56


--
Pete_UK
------------------------------------------------------------------------
Pete_UK's Profile: http://www.thecodecage.com/forumz/member.php?userid=205
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=83096