converting decimal to Time format

[Sean15]

The start time in column A is in decimal format. I'm trying to display the actual time in column B, but the numbers are showing up as text instead. I’ve attempted to use a custom number format, but it doesn’t seem to affect the display. I think I’m approaching this incorrectly—could you help, please?

sample.xlsx
	A	B	C	D
1	System	Actual		Actual
2	End Time	End Time		should be
3	8.12	8:7		8:07
4	9.02	9:1		9:01
5	8.20	8:492		8:12
6	8.48	8:29		8:29
7	7.90	7:474		7:54
sheet1

Cell Formulas
Range	Formula
B3:B7	B3	=LEFT(A3,1)&":"&ROUND(RIGHT(A3,3)*60,0)

 

[Sean15]

My sincere apologies for this post. I found the solution.