Try one of solutions below:
Your data in column A; the excel formula under column B; the Time value
shown under column C. Apply the formula.
Hope this helps.
Thanks

Your data Excel formula Time valu
1.05 =TIMEVALUE(""&LEFT($A2,FIND(".",$A2)-1)&":"&MID($A2,FIND(".",$A2)+1,2)&":00") 1:05:00 A
2.03 =TIMEVALUE(""&LEFT($A3,FIND(".",$A3)-1)&":"&MID($A3,FIND(".",$A3)+1,2)&":00") 2:03:00 A
0.03 =TIMEVALUE(""&LEFT($A4,FIND(".",$A4)-1)&":"&MID($A4,FIND(".",$A4)+1,2)&":00") 12:03:00 A
16.06.49 =TIMEVALUE(""&LEFT($A5,FIND(".",$A5)-1)&":"&MID($A5,FIND(".",$A5)+1,2)&":00") 4:06:00 P
16.06 =TIMEVALUE(""&LEFT($A6,FIND(".",$A6)-1)&":"&MID($A6,FIND(".",$A6)+1,2)&":00") 4:06:00 PM


"cs_vision" wrote:

I have a spreadsheet that contains general text: 1.05, 2.03, 0.03
This is really time (i.e., 1.05 equals 0:01:05). How do I convert this
general text to time values?