Hi Ron

Excel stores it's times as fractions of a day (24 hours)
Format the cell as hh:mm
then with 6.15 in cell A1 =A1/24


--
Regards
Roger Govier

"Ron" wrote in message
...
I get an exported excel file that has the time in hours/hundredths and I
have
to convert it to hours/minutes - example 6.18 = 6:11, 6.15 = 6:09, etc.
I'm doing the conversion but it takes me about 4 passes - is there a
simple
way to convert this kind of time. Thank You

__________ Information from ESET Smart Security, version of virus
signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4743 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com