Converting Text to Time 1

[Poweruser99]

I have imported a large data file in to Access. I have a whole bunch of values for time. They are in a text format and I need to convert them to time.

Activity Start Time
083000
093200
090500
100500
092800

I need to get it into the following format.

8:30
9:32
9:05 and so forth

Is there a function that can help me with this?

 

[SkipVought]

Hi,

TimeSerial(hour, minute, second)

Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}

 

[Poweruser99]

How would u incorporate the TIMESERIAL function in the query?

would it be timeserial(text),(hour, minute, second)

 

[PHV]

Have a look to the Left, Mid and Right functions too.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

TimeSerial(Left([Activity Start  Time],2), Mid([Activity Start  Time],3,2), Right([Activity Start  Time],2))

Skip,

_{[red]Be Advised![/red] Coeds studying ancient Egyptian plumbing, might be known as...
Pharaoh Faucet Majors}

 

[Poweruser99]

Thanks it worked!!!