Text or numbers to hh:mm

[quinto via OfficeKB.com]

I have a column that has numbers as followed 630, 530, 1030 represting times,
I need to convert these numbers to 6:30, 5:30, 10:30 and so on.

Thanks
Quinto

 

[David Biddulph]

=--TEXT(A2,"00\:00") and format as time.

 

[Billy Liddel]

Excellent David

Regards
Peter

=--TEXT(A2,"00\:00") and format as time.