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.