First remove your manual alignment. You now see that some contents are left aligned, they are text
To change the text time values to real time values, just select the range - Data Text To columns - Finish
Now all should be " right aligned" and thus are numbers
"Formatting " is just how XL lets you see the values. The underlying values are still numbers, so =1/24 ( which is one hour) could be shown as 01:00:00, but the underlying value still is 0.0416667