Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 13:12:57 +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)