I imported a column of min:sec data from Crystal reports XI. However when I
open in Excel, Excel has dropped the : and substituted a . Hence as an
example what should be 16:36 (min:sec) shows in Excel as 16.36

How can I convert something like 16.36 to min:sec?

And secondly, how could I convert 16.36 to a true minutes and hundreths of
a minute?

Any help appreciated!

Mike