Logic Statement using Time Field

[adario]

I'm very new, so be gentle.

I'm trying to find times during which I have more than 2 tests booked after 4:30 pm. If this is the case than I have to recruit an extra person to work during that extended test period.

I tried using a simple logic statement to find and count the time field, but I consistantly encounter errors (e.g. 9 or 9:30 am is counted as well.)

I just used this...

Case(timefield >= "4:30 pm";1;"")

Though the time entered could have been keyed-in as 4:30pm, 4:30 p.m., etc., the time was formatted as 4:30 pm

Can I not use Case for a time field?

Thanks for your help

Amy :o

[Anuviel]

When creating a time field you could check the option of require strict data type and set it to time of day so the user will be forced to enter the time in the same format always or you could just use formatting so that when someone enters 9 or 9:30pm the field will always return 9:30 PM.

Example with the phone number:

"(" & Left(Phone;3) & ") " & Middle(Phone;4;3) & "-" & Right(Phone;4)

Do not take me for my word, I am new here too.

[mr_vodka]

Your issue is not using a Case with a time field. It is what you are comparing it to.

Try.

Case ( timefield >= GetAsTime ( "16:30" ); 1 )

[adario]

John, THANK YOU! it worked

thanks

Amy