Converting Numbers to Time

Greetings all...thank you for reading.

I am encountering a vexing problem when trying to convert a column of numbers (in 0000 or 000 format) to time (in 00:00 or 0:00 format). I have used the Format Cells function but it takes all my numbers and changes them to 00:00, so a number like 142 should become 1:42, instead it becomes 0:00. Not what I want...these numbers are for a pilot logbook and without the ability to convert them properly my new $130 logbook program is useless!

Your assistance is greatly appreciated.

aj1125

When you say 1:42 do you mean 1 hour and 42 minutes? You won't be able to convert with formatting. You could use a formula in another column. If 142 is in A1 then use this formula in B2

=TEXT(A1,"00\:00")+0

then format B1 as [h]:mm

This will convert your 3 and 4 digit numbers