Semaphore Classification

[GartoJsar]

Semaphore Classification

Hello good mornig for everyone.

I need your help, I am trying to add a report where I colored the columns see and red.

Then I have to implement the states of tikets, if I generate if a tiket was generated on 10/08/2018 12:25:29 pm, the tiket has to be solved in 4 hours after the survey 10/08/2018 16:25 : 29 pm If the tiket was resolved before the time 10/08/2018 16:25:29 pm mark the line green, but if the tiket was resolved after 10/08/2018 16:25:29 either a second or more minutes and even hours or days, mark it red.

I do not know how to apply in the formula, so that I consider the time of the minutes and seconds.

I leave you assign an example for better understanding

I hope you can tell me how to solve this issue.

Thank you so much.

[m_woolf · Accepted solution]

4 hours is 1/6 of a day. You should be able to do some sort of expression like:

=if(num(DataResolc=ved)-num(DateOpened)<=1/6, green(),red())

[GartoJsar]

thank you very much m w.

your comment helped me a lot

Thank you

[GartoJsar]

thank you very much m w.

your comment helped me a lot

Thank you