16.36 convert to 16:36 (min:sec)
Both these work. Thank you. You are my hero!
Mike
"Fred Smith" wrote:
With your number in a1, you can convert to a time with:
=time(0,int(a1),(a1-int(a1))*100)
To convert to a number of minutes, use:
=int(a1)+(a1-int(a1))*100/60
--
Regards,
Fred
"Sailonmike" wrote in message
...
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
|