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:
- to use the extract function on the date you have to get just the hour ‘HH’ portion of it
- then use conditional formatting for the coloring.
I was able to test this successfully in my account, posting here the steps I followed:
- Create a calculated field (hour) to extract the hour from the date field:
- 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.