if statement between 2 times

column 1, auto date with time, "12/09/21 1:07 PM"

column 2 is my play column

column 3 i do a =RIGHT(([date auto]@row), 8) to get just the time "1:07 PM"

column 4 was trying to do a T/F if the time is after 3pm but befor 12am (or can use 11:59pm)

if have tried several thing, and can not get it to work.

got any ideas?

Find more posts tagged with

Accepted answers

All comments

if you can convert in 24h format you could use something like this

=IF(OR(RIGHT(100 + VALUE(LEFT(time@row; FIND(":"; time@row) - 1)); 2) > 14; RIGHT(100 + VALUE(LEFT(time@row; FIND(":"; time@row) - 1)); 2) < 12); "T"; "F")

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.