Support Board
Date/Time: Mon, 25 Nov 2024 11:15:47 +0000
Post From: Spreadsheet time subtraction formula
| [2024-03-16 00:33:42] |
| Sawtooth - Posts: 4120 |
|
show me the current time minus the number of minutes referenced in another column.
One minute in SerialDateTime is 1/1440, because there are 1440 minutes in 24 hours.Spreadsheet Example Formulas and Usage: Using Date Time So 10 minutes is 10/1440 If you are referencing column A that has the bar's timestamp, this would be the formula: =FRACTIME(A3)-10/1440 If the offset minutes are in column P: =FRACTIME(A3)-P3/1440 |