On Monday, 4 January 2010 17:36:01 UTC+1, 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

I'm using all this suggested formulas but it doesn't return the value that I want. I have 7.50 (employee works 7 and a half hour per day), which should come back as 7:30 - number of hours, not the time 7:30am. I keep getting the time, not the number of hours. what am I doing wrong?