Support Board
Date/Time: Mon, 25 Nov 2024 09:50:52 +0000
Spreadsheet time subtraction formula
View Count: 199
| [2024-03-15 20:27:44] |
| User827002 - Posts: 36 |
|
In a spreadsheet, I'm trying to get a column to show me the current time minus the number of minutes referenced in another column. For example, in column A if it shows 10, and the time is 12:00, I want column B to show 11:50 as a time value that I can reference. Do you know what formula I can use for this?
|
| [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 |
To post a message in this thread, you need to log in with your Sierra Chart account: