Jump to content
We've recently updated our Privacy Statement, available here. ×

Logical calculation based on [Date/Time] Column


Lou Reyes

Recommended Posts

One of the columns that's imported into my table is a Date/Time column in the format "5/17/2019 9:40:01 AM".

I'm trying to create a calculated column that would stamp 'First stage', 'Second stage', 'Third stage' based on key time markers at 10:15 AM, 12:30 PM, and 2:45 PM.

Have not been able to create a formula to achieve it... and when trying the functions Hour in combination with Minute... typically restricts it toa fixed hour slot.

 

I thoughtthis was an easy task... but I seem to be overlooking something.

Any thoughts are much appreciated!

Lou

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...