Text or numbers to hh:mm
 

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

--
Message posted via http://www.officekb.com

Text or numbers to hh:mm
 

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

"quinto via OfficeKB.com" <u35571@uwe wrote in message
news:80d6ceba688c6@uwe...
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

--
Message posted via http://www.officekb.com

Text or numbers to hh:mm
 

Excellent David

Regards
Peter

"David Biddulph" wrote:

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

"quinto via OfficeKB.com" <u35571@uwe wrote in message
news:80d6ceba688c6@uwe...
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

--
Message posted via http://www.officekb.com