A1=1436

in B1:

=TIME(LEFT(A1,LEN(A1)-2),RIGHT(A1,2),0)

B1 ==> 14:36

Format cell as hh:mm

HTH

"Lesley" wrote:

> I have an Excel file with a Time column formatted as a general number (e.g.
> 830, 1102, 805). I need to convert these numbers to a time format like 8:30,
> 11:02, and 8:05.
>
> I've tried =TEXT(a2,"h:mm"); however, it only returns a zero. These data
> will be imported into a time formatted field in Access and later used to
> determine the difference between schedule delivery time versus actual
> delivery time.
>
> Any assistance on how to convert this field would be very helpful. Thanks!