Login Page - Create Account

Support Board


Date/Time: Sun, 16 Mar 2025 14:32:04 +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 J41

There 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