Thanks Pete It worked Like a dream you guys are GREAT (you'all) saved me
weeks of converting those cells on paper then, typing them into the cells
"Pete_UK" wrote:
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