Number to Time Conversion

[Richard G]

I am using MS Access 2000 and have imported some raw data one of the rows of data shows a time but displays this as a general number ie; 1246 or 745 is there any way I can convert this number into a time, 24hr would be nice, so 1246 displays as 12:46 and 745 displays as 07:45 or 1530 displays as 15:30 ?

Best Wishes

Richard

 

[Mido]

convert a number to time

there you go