Support Board
Date/Time: Thu, 06 Nov 2025 07:20:29 +0000
Post From: How to calulate last 20minutes in spreadsheet
| [2022-08-02 22:07:17] |
| Sawtooth - Posts: 4285 |
|
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) |