Support Board
Date/Time: Tue, 13 May 2025 01:52:40 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-02 14:37:30] |
| Sawtooth - Posts: 4214 |
|
OK, try this in K3 for any chart type, any session times: =IF(OR(AND($J$75>$J$76,A3-INT(A3)>=$J$75,A4-INT(A4)<$J$75),AND($J$75<$J$76,INT(A3)>INT(A4))),K4+1,K4) |