Login Page - Create Account

Support Board


Date/Time: Sun, 24 Nov 2024 09:08:41 +0000



Post From: Flatten or Cancel Spreadsheet trading

[2013-10-04 18:20:43]
toews&kane - Posts: 209
Hi there,

I am using this code in J29 it doesn't seem to be working. I just want it to flatten at 16:09:00
It's returning true right now. Suggestions?

=AND(OR(J41-INT(J41)<TIMEVALUE("16:00:00"),J41-INT(J41)>TIMEVALUE("16:30:00")))