Use a help column and this formula (time data supposed to be in E10):

=TEXT(E10;"hh:mm") copy down as required

Then copy the help column and paste--special--values over your
original column and then delete the help column.

Hans