convert text to number

[sumsaam]

Hi
i have an excel sheet from time attendance machine with time stamps on in and out times of my staff. problem is that this data is not in number form. excel formulas are not working on this format how to convert this data into proper format. MID function is used to split time stamps in different cells like this
11:22
13:29
14:55

i have to use -- sign with Mid function than it was working fine. how to correct data format where mid function is not used please help. thank you

 

[mole999]

do you get
[TABLE="width: 72"]
<colgroup><col style="width:54pt" width="72"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 72"]0.473611[/TD]
[/TR]
[TR]
[TD="class: xl63"]0.561806[/TD]
[/TR]
[TR]
[TD="class: xl63"]0.621528[/TD]
[/TR]
</tbody>[/TABLE]
in which case you need to format as h:mm