Question: how to convert hhmm to time in excel?
Answer: Enter the formula in cell B2.
=--TEXT(A2,"00\:00\:00")
Function will return the number.
Format the cells in to hh:mm:ss.
Copy the same formula in the range.