Support Board
Date/Time: Thu, 13 Feb 2025 17:00:29 +0000
Post From: Spreadsheet programming question
| [2020-12-09 16:22:29] |
| Sawtooth - Posts: 4173 |
|
how would I determine how many seconds into the bar has passed?
Try this:=ROUND(($J$41-$A$3)*86400,0) This subtracts the current chart time from the bar's start time, then multiplies it by the number of seconds in 24 hours, then it is rounded to the nearest whole second. In the SerialDateTime format, the integer is the number of days since 1/1/1900, and the decimal is the fraction of the day. If you want to display this value, put the formula in row 3 of a Formula Column, and use the Text Display for Study study, referencing the spreadsheet study column/subgraph. |