How do you convert decimals to seconds in Excel?

Right click the cell. Choose Format Cell. Choose custom format. Type m.ss

Click Ok.

The seconds function might help. Example. pic

Ignore that..

I’ve been playing with the custom formats, but with little luck.
You’re on to something, though. m.ss makes 20,70 into 51,54. Problem is that I do not want to convert the minutes, just the seconds. So the result should be 20,54

By the way – I live in Denmark, and we switch . for , when typing numbers.

just multiply the decimal column by 60

After much googling, F1’ing and playing around I finally solved it.My Excel skillz are not what they used to be :-) Frankly there has to be a more elegant solution to this…
http://i42.tinypic.com/2vx3kfd.jpg

I’m pretty proud of my achievement, but quite embarrased that it took so much work to figure it out :-)

=INT(KM/KMH*60)&”.”&TEXT(ROUND(ABS(INT(KM/KMH*60)-(KM/KMH*60))*100;2)*0,6;“00”)

Or as it appears in the spreadsheet:
=INT($A2/B$1*60)&”.”&TEXT(ROUND(ABS(INT($A2/B$1*60)-($A2/B$1*60))*100;2)*0,6;“00”)