Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 16:45:53 +0000



Post From: Bar Time Length in Spreadsheets

[2023-07-30 00:43:29]
Sawtooth - Posts: 4120
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@3*1440
To convert to seconds:
=ID1.SG1@3*86400
where ID1 is the Bar Time Duration study.