Ron,

You have a number of options, depending on what you need. The simplest is to format a cell for
time, and in the cell use a formula like

=A2/24

Where A2 has the 6.18 value.

HTH,
Bernie
MS Excel MVP


"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