Is there a simple formula to convert time in hundredths to minute
So you want to convert decimal hours to an Excel time? If so, you want:
=a1/24
Format as time.
Regards,
Fred
"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
|