Convert text numbers to decimal time

[y_not]

Hi,

I have a CSV file with employee hours in but they are all formatted as text and display such as 10.38333333605 or 9.466666667443.

I need them to display as 10.50 and 9.75 - can anyone assist with a solution, please?

Many thanks

[Bo_Ry]

Not sure how you convert .383 to 0.50 and .466 to .75

My guess is divide by 0.60
Number in A1:A2

Please try at B1

=ROUND(INT(A1)+MOD(A1,1)/0.6,2)

[Glenn Kennedy]

I was baffled by this, too!!

[rajansettu]

hi,

try below one...

=LEFT(A1,FIND(".",A1))&MROUND(LEFT(RIGHT(A1,LEN(A1)-FIND(".",A1)),2),25)

[Bo_Ry]

Thank rajansettu

Now I see pattern.

=INT(A1)+FLOOR(MOD(A1,1)/0.6,0.25)

[Phuocam]

Or try:

=FLOOR(DOLLARDE(A1,60),0.25)