Support Board
Date/Time: Sun, 16 Mar 2025 11:54:35 +0000
Post From: How to calulate last 20minutes in spreadsheet
[2022-08-11 13:31:58] |
Sawtooth - Posts: 4184 |
I am struggling how to calculate last 20 minutes from current time.
The current chart datetime is in J41There are 1440 minutes in 24 hours, so 20 minutes is 20/1440 So the datetime 20 minutes ago is: =J41-20/1440 The time 20 minutes ago is: =FRACTIME(J41)-20/1440 |