convert numbers into times

  • Thread starter Thread starter shital
  • Start date Start date
S

shital

i have mumbers in column b like 1240,1350,0545, etc..
i.e. b2 1240
b3 1350
b4 0545

how can i convert that numbers into times in column c
like c2 12:40
c3 13:50
c4 05:45
plz help.

Shital
 
Shital,

This formula does it for you
=TIME(INT(A1/100),A1-INT(A1/100)*100,0)

just make sure it is formatted as time.
 
You need to format it as time. Select the cells, press
Ctrl+1, click Number tab, click Time, and choose the
desired time format on the right-hand side.

Jason
 
Back
Top