if statement between 2 times

Stephen Hindes
ββ
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?
Answers
-
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")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!