Send to a Friend

Jbor's avatar

How do you convert decimals to seconds in Excel?

Asked by Jbor (649points) 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

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.