Text to short time

[quinto via AccessMonster.com]

I did some research but what I found I could not use.
Table linked to an external xls sheet all numbers and time are text formatted.
The time looks like it is formatted in short time but it is not, it is text.
I am using an append query to get it into another table but I must convert
time in txt format to short time format.
I got a lot of help from this site and I hope someone has the patience to
help me out

Thanks

Quinto

 

[raskew via AccessMonster.com]

Hi Quinto -

You can use the DateValue() and TimeValue() functions to return an actual
date or time. Example, from the debug (immediate) window:

x = "8/23/2008 9:41:33 AM"
? x
8/23/2008 9:41:33 AM

? datevalue(x)
8/23/2008

? timevalue(x)
9:41:33 AM

HTH - Bob

 

[quinto via AccessMonster.com]

Thanks you.
I finally figured out and used the following exp NStart: CDate(Format(
[NewStart],"Short Time"))

Hi Quinto -

You can use the DateValue() and TimeValue() functions to return an actual
date or time. Example, from the debug (immediate) window:

x = "8/23/2008 9:41:33 AM"
? x
8/23/2008 9:41:33 AM

? datevalue(x)
8/23/2008

? timevalue(x)
9:41:33 AM

HTH - Bob

I did some research but what I found I could not use.
Table linked to an external xls sheet all numbers and time are text formatted.

[quoted text clipped - 7 lines]

Quinto