Support Board

Date/Time: Thu, 06 Nov 2025 01:24:41 +0000

Bar Time Length in Spreadsheets

[2023-07-29 16:10:09] #1 [Go To First Post]
Le Dharma - Posts: 86
Hey Sierra, I am looking for a function or study that returns the length of time a bar exists for. I would like to use this for a Trades per Bar chart. Do yall have anything like that? Thanks for your time, -LD

[2023-07-30 00:43:29] #2 [Go To First Post]
Sawtooth - Posts: 4285
Use the Bar Time Duration study. It returns the duration in Serial DateTime format. To convert to minutes, use a formula like this: =ID1.SG1@31440 To convert to seconds: =ID1.SG1@386400 where ID1 is the Bar Time Duration study.

To post a message in this thread, you need to log in with your Sierra Chart account: