Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting minutes to seconds | Excel Worksheet Functions | |||
Converting hours:minutes:seconds to just minutes | Excel Worksheet Functions | |||
Converting to minutes and seconds | Excel Discussion (Misc queries) | |||
converting Minutes to Seconds | Excel Discussion (Misc queries) | |||
Converting minutes to seconds | Excel Discussion (Misc queries) |