Find function case sensitive

Sharon Castiglia

Hello,

I have the following formula that only works if a time is entered hh:mm pm. I can't seem to find a way to get this to accept PM. Only works with pm.

=IF(FIND("pm", [Tech Arrival Time]@row) > 0, "P", "A")

Exhausting my resources before dictating how time is entered.

Thank you in advance

Sharon C.

Paul Newcome

If it is manually entered then you can use a CONTAINS function which is not case sensitive in place of the FIND.

=IF(CONTAINS("pm", [Tech Arrival Time]@row), "P", "A")

Paul Newcome

How is the data in [Tech Arrival Time]@row entered? Is it part of a date/time stamp system column, or is it manually entered?

Sharon Castiglia

Hello Paul,

The Tech Arrival Time is entered by the tech onsite.

Paul Newcome

If it is manually entered then you can use a CONTAINS function which is not case sensitive in place of the FIND.

=IF(CONTAINS("pm", [Tech Arrival Time]@row), "P", "A")

Sharon Castiglia

Thank you so much.

Paul Newcome

Happy to help. 👍️