Converting text to numbers

[ordnance1]

I have to import a report into excel which contains times in to
columns. The time is formated as 9:45 and 11:23 (as an example). when
the times are pasted into Excel the times with 4 digits (11:23) excel
automaticly sets the cell formula to hh:mm but if the time only has 3
digits (9:45) excel automaticly sets the cell format to general. I
have tried formating the cells as hh:mm prior to pasting but that did
not help.

Any ideas how I can convert the 9:45 to the proper time format?

 

[Guest]

=TIME(LEFT(A1,1), RIGHT(A1,2),0)

format cells as hh:mm

 

[Guest]

You have to perform a methamatical operation over the time values to convert
them from text.
Type 1 in any cell and copy. Select time column. Paste special. Multiply
Format column as hh:mm