Send to a Friend

Jbor's avatar

How do you convert decimals to seconds in Excel?

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.

Mobile | Desktop


Send Feedback   

`