View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eva Eva is offline
external usenet poster
 
Posts: 197
Default Is there a simple formula to convert time in hundredths to minute

Can you tell us more about it? I don't understand why 6.18 = 6:11 or 6.15 =
6:09.
--
Greatly appreciated
Eva


"Ron" wrote:

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