Support Board
Date/Time: Wed, 05 Feb 2025 12:56:38 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-12-02 23:03:17] |
| Sawtooth - Posts: 4167 |
|
Have you ever considered being a Beta tester? :) OK, I think the K3 formula will now handle any chart type, any session times, including an Intraday 1-0-0 chart that doesn't start at midnight. Post #27 has the updated files. Here's the new K3 formula, if you don't want to download the files: =IF(OR(AND($J$75>0,MROUND(A3-INT(A3),1/86400)=MROUND($J$75,1/86400)),AND($J$75=0,INT(A3)>INT(A4))),K4+1,K4) |