Support Board
Date/Time: Sat, 21 Feb 2026 23:39:35 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-02 05:15:09] |
| Sawtooth - Posts: 4313 |
|
=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. |