Support Board
Date/Time: Sat, 08 Nov 2025 20:52:28 +0000
Post From: Spreadsheet system for trading question
| [2016-08-29 20:38:50] |
| Sawtooth - Posts: 4287 |
|
Use OR instead of AND when crossing midnight: =OR(J41-INT(J41)<TIMEVALUE("05:00:00"),J41-INT(J41)>TIMEVALUE("14:55:00")) |
