Number to Time Conversion

Richard G

Registered User.
Local time
Today, 01:57
Joined
Jul 16, 2006
Messages
22
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
 

Users who are viewing this thread

Back
Top Bottom