Support Board

Date/Time: Sun, 11 May 2025 00:15:40 +0000

Post From: Spreadsheet exit question

[2014-04-09 21:01:36] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4214
Try this: =OR(J41-INT(J41)>TIMEVALUE("15:05:00"),IF(J8>0,OR(AND(AA4<AE4,AA5>AE5),AND(AA4<AG4,AA5>AG5)),IF(J8<0,OR(AND(AA4>AE4,AA5<AE5),AND(AA4>AG4,AA5<AG5)),FALSE)))