Help with formula for after hours report

[mvalley]

I have a report that needs to pull different time frame data. I need to show all cases that start after 2000 and finish before 0630 for an after hours report. Suggestions on what type of formula I can write?
Field is {time_pat_in_room}

 

[lbass]

If there is only one time field {time_pat_in_room} for both start and end, how do you know which time field is associated with the start versus the end? Do you have a date field also?

-LB

 

[mvalley]

I was able to finally figure out how to acheive the results I need. Thank you for responding to my request. I find this forum invaluable to a newbie lie myself.

 

[lbass]

I think you should explain what you did so that the thread is useful to others.

-LB