Time Function in Conditional Formatting

[Michele317]

Hello,
I'm having some trouble with the conditional formatting.
I would like to insert a formula in it that includes the "Time" function.
What I write is:

=O$3>N$3+TIME(0,30,0)

The conditional formatting have simply to check if the time value in a cell is greater than the time value in another cell + 30 minutes.
I tried to delete the "TIME" function part and it seems to work. So, the other 2 cells are not the problem.

How can I fix this?

Thank you,
Michele

 

[Michele317]

Find the second error. I must be too tired for not seeing those...
I wrote (in the conditional formatting) "O$3>N$3+TIME(0;30;0)" while referring to cells O6. So i should have write O$6>N$6+TIME(0;30;0).

I thank you so much @Joe4. And sorry for bothering you for such silly errors. I though I had bigger issues.
I think it's time for me to take a long break.
Thank you again and I wish you a Happy Christmas

 

[Joe4]

I don't know that Excel likes negative times, like you have in K6 and P6.
If I try to enter in a negative time in any cell in Excel, I get an error.

Can you do me a favor, and temporarily change the cell format of cells K6, N6, O6, and P6 to "General", and let me know the exact value (up to 5 decimals) that appears in each of those cells?

 

[Michele317]

I don't know that Excel likes negative times, like you have in K6 and P6.
If I try to enter in a negative time in any cell in Excel, I get an error.

Can you do me a favor, and temporarily change the cell format of cells K6, N6, O6, and P6 to "General", and let me know the exact value (up to 5 decimals) that appears in each of those cells?

Probably you missed my last post (see above), but I have fixed the other error Thank you again.
Also, I set negative time by activativing 1904 system date. So, by changing the format value, I get a negative decimal number

 

[Joe4]

Ah, OK. I missed that!

Glad you got everything working now.
Happy Christmas to you too!