Issue with Dates ans Hours

[Paulo_Novas]

Hi! need help, trying set periods of the day in a table like from 8:00 to 12:00 - 12:00 16:00 …

Trying to use IF Then, but in the before or afther there is no custom so i can get an hour but not the ones before

sorry would be easy but i did not find

regards

[MaximeBaker]

Did you mean that you want something like that:

• If Time is before 12:00 → "Morning".
• If Time is before 16:00 → "Afternoon".
• If Time is before 20:00 → "Evening".
• Else → "Night"?

[Paulo_Novas]

Hi MaximeBaker,

Yes would solve my problem

Regards

[MaximeBaker]

First, create a Math column to get only the hours:

Then, create your if-then-else column like this:

[Paulo_Novas]

Hi Max,

Great many thanks! It is working now

[MaximeBaker]

My pleasure !!!