Determining AM or PM Shift Question

Ronald Anderson

I there a way to determine if an employee works an AM or PM shift based on the following text? There are appox. 67 different schedules.

4/40 Sunday - Wednesday 8:00 PM - 6:30 AM 30 Min Lunch

4/40 Sunday - Wednesday 6:00 AM - 4:30 PM 30 Min Lunch

There are appox. 67 different schedules.

Thank you!

Ron

Paul Newcome

There is also a misplaced parenthesis.

=IF(OR(AND(FIND("AM",[Shift]@row)<FIND("PM",[Shift]@row),FIND("AM",[Shift]@row)<>0), FIND("PM", [Shift]@row)=0),"AM","PM")

Zachary Hall

Hi,

Assuming all you would need is whether the start time is in the AM to determine this, you could use a formula like this in a column:

• IF(OR(AND(FIND("AM",[Shift]@row)<FIND("PM",[Shift]@row),FIND("AM",[Shift]@row<>0)), FIND("PM")=0),"AM","PM")

I hope this helps!

Ronald Anderson

Thank you Zach for your assistance. I am receiving an Incorrect Argument Error. Here is a screen shot to help.

Zachary Hall

Sorry! I missed a necessary field there:

• IF(OR(AND(FIND("AM",[Shift]@row)<FIND("PM",[Shift]@row),FIND("AM",[Shift]@row<>0)), FIND("PM", [Shift]@row)=0),"AM","PM")

Paul Newcome

There is also a misplaced parenthesis.

=IF(OR(AND(FIND("AM",[Shift]@row)<FIND("PM",[Shift]@row),FIND("AM",[Shift]@row)<>0), FIND("PM", [Shift]@row)=0),"AM","PM")

Ronald Anderson

It is working properly now. Thank you both for your assistance.

Ron

Paul Newcome

Happy to help. 👍️