Time Query

  • Thread starter Thread starter TA
  • Start date Start date
T

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
 
Hello,
I have a text field contain time (like 9:20 PM)
Click to expand...

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
Click to expand...

Just what do you mean by "calculate the count"?
What is the good way to define the field type for it?
Click to expand...

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.
 
Back
Top