Support Board
Date/Time: Wed, 05 Feb 2025 15:49:06 +0000
Post From: Spreadsheet Rolling Pivot - Session End Time
| [2014-11-20 14:01:17] |
| Sawtooth - Posts: 4167 |
|
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. |