I have some data being pulled in by a query program from an AS/400 system. Unfortunately the times I am pulling in are not in a numeric format. The numbers below represent actual times in 24-hour format (ex. 21:30, 2:13, 4:45, & 22:24). I would like to change them to a decimal time format (ex. 21.50, 2.22, 4.75, & 22.4).
213000
21300
44500
222400
213000
21300
44500
222400