Send to a Friend
How do you convert decimals to seconds in Excel?
Asked by Jbor (649)
February 13th, 2009
I’ve created a spreadsheet to trak my running progress as detailed here: http://i40.tinypic.com/153y1xk.jpg
Rows are Km/hour, columns Km. What I wish is to display the decimals as seconds (base 60) instead of base 100. In other words 20½ minutes should be 20,30 and not 20,50 as is currently the case.
Using Fluther
or