How do I convert a # into a time format in Excel, Ex.845 to 8:45

T

twilliams

I have tried to format the cell with a time format. It brings up my times
all as 0:00. I want them to convert to time without me wasting time to enter
the colon between the numbers every time. I want them to convert for example
845 to 8:45.

Can you help me?
 
D

Dav

times are stored as part of a day so for example 6am is 0.25, midday i
0.5,

To convert your times If the time is stored in cell a1 try somethin
like

=INT(A1/100)/24+MOD(A1,100)/24/60

Regards

Da
 
M

Miguel Zapico

If you always have that format, you can use the following formula:
=TIME(INT(A1/100),MOD(A1,100),0)
Hope this helps,
Miguel.
 
Top