Support Board

Date/Time: Thu, 05 Feb 2026 08:31:25 +0000

Post From: How to calulate last 20minutes in spreadsheet

[2022-08-11 13:31:58] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4312
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