Support Board
Date/Time: Sun, 16 Mar 2025 15:46:26 +0000
Post From: How to calulate last 20minutes in spreadsheet
| [2022-08-02 22:07:17] |
| Sawtooth - Posts: 4184 |
|
Try this: Cell T1: =FRACTIME(A3)-20/1440 Cell T3: =FRACTIME(A3) Cell U3: =INDEX(T$3:T$1002,MATCH($T$1,T$3:T$1002,-1),1) Cell V3: =IF(U3=T3,1,V4+1) |