I have a Time column and I need to know if the time is greater than 11:59 PM. I have been playing with different formulas and can’t seem to get it to show true…
Any help would be greatly appreciated.
PS. This is my fist day playing around with Coda from Excel and Notion…
Hi @Douglas_Marzean
I think u need to use also seconds to get the result you want, becouse u have only 60 seconds more to midnight and then the day is restarted and the day starts with 12:00:00 AM in your case. Thats always less than 11:59:00PM. Maybe it helps im adding a picture of table i made and the u can get the true but only if you add seconds.
Tomas
I’m am idiot… Of course 12:00 AM will never be true. Too much screen time today!
