Support Board
Date/Time: Fri, 04 Jul 2025 10:03:13 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-02 05:15:09] |
| Sawtooth - Posts: 4231 |
|
=IF(AND(A3-INT(A3)>=$J$75,A4-INT(A4)<$J$75),K4+1,K4) can only be used on an Intraday chart =IF(INT(A3)>INT(A4),K4+1,K4) must be used on an Historical chart, or on an Intraday chart when you want the lines to change at midnight. |