Time Query

[TA]

Hello,
I have a text field contain time (like 9:20 PM)
How can I calculate the count between 2 different time.
Ex:
8:00 AM to Noon
Noon to 5:00 PM
What is the good way to define the field type for it?

Best regards,
TA

 

[John Vinson]

Hello,
I have a text field contain time (like 9:20 PM)

A Text field is not a time - you'll need to use the CDate() function
to convert it to a date/time field.

How can I calculate the count between 2 different time.
Ex:
8:00 AM to Noon
Noon to 5:00 PM

Just what do you mean by "calculate the count"?

What is the good way to define the field type for it?

I'm *GUESSING* that you will want to put

RealTime: CDate([texttime])

in a vacant Field cell, and use a criterion of

BETWEEN #08:00 am# AND #12:00 pm#

The word "noon" is not a valid time value.