Support Board
Date/Time: Mon, 23 Dec 2024 00:56:54 +0000
Post From: simple counting spreadsheet cell
| [2015-05-25 18:41:32] |
| Sawtooth - Posts: 4141 |
|
This counts from 1 to 20 at each new row, then starts at 1 again, in cell P3: =IF(OR(MROUND(A3-INT(A3),1/86400)=0,P4=20),1,P4+1) It starts at midnight, but you could start it at any time, or at any one-time event. |