Convert number to hh:mm format

[acharyyat]

Dear members,

Is there any easy way to convert following two numbers into hh:mm time format in excel.

For example,

812 = 08:12
1545= 15:45

I have a long list of such military times to convert to proper excel time format.

Thank you

 

[Dave Patton]

Time 2023.xlsm
	A	B
1
2	812	08:12
3	1545	15:45
4
1h

Cell Formulas
Range	Formula
B2:B3	B2	=--TEXT(A2,"00\:00")

format as time