Changing number format to time format issue

  • Thread starter Thread starter Iain
  • Start date Start date
I

Iain

guys/gals,

I am importing data from another database and would like
to change the time format so I can use it for calculations.

The time at present is imported as a number format, 0830,
0900, 0930 etc, and I would like to change this to 08:30,
09:30, 09:30 etc.

I am having trouble doing this, so if anybody has any
pointers, ideas or can direct to somewhere that does then
it would be greatly appreciated.

Thanks,
Iain
 
Use a calculated field in a query.

If the text field is called "TextTime", the calculated field would be:
CDate(Format([TextTime], "00\:00"))
 
Back
Top