Need to add conditional formatting on the basics of Time like HH

I have a date filed like dd-MMM-yyyy HH:mm:ss A I need a calculation where I put the condition on the basic of time period.
If the time is between 6:00 AM to 6:59 AM then it is Green
If the time is = 7:00 AM then Amber
If the time >7:00 AM then Red

I posted the same question yesterday and got replied from @Max but not able to get the exact result what I need .Any idea please suggest

Hello, here what @Max was suggesting in the other topic is:

  1. to use the extract function on the date you have to get just the hour ‘HH’ portion of it
  2. then use conditional formatting for the coloring.

I was able to test this successfully in my account, posting here the steps I followed:

  1. Create a calculated field (hour) to extract the hour from the date field:
extract('HH', {your_date_field_here})
  1. Use the conditional formatting with the rules depicted below in the hour field:

Hope it helps, please mark this solution as solved if that’s the case also to help other members of the community., otherwise let us know.

Happy dashboarding!