Support Board
Date/Time: Tue, 13 May 2025 03:09:21 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-11-20 14:01:17] |
| Sawtooth - Posts: 4214 |
|
Use this formula in K3 instead: =IF(AND(A3-INT(A3)>=$J$75,A4-INT(A4)<$J$75),K4+1,K4) This will shift the lines at the Session Start time. The Session End time is in J76. Edit the formula if you'd rather use it. |