Support Board

• Support Board |
• Search Board |
• Control Panel |
• View My Posts / Threads |
• Direct Messages

Date/Time: Wed, 05 Nov 2025 19:37:28 +0000

Spreadsheet - formating to seconds

View Count: 480

[Page 1 of 1] First Page -- 1 -- Last Page

[2022-07-20 09:05:58] #1 [Go To First Post]
User361939 - Posts: 169
Hello, I am trying to get duration for bar in seconds. In excel it's a simple changing format [ss], so the difference in bar time is presentented in seconds. In spreadsheet i can only change format to time so i can see like at the attachment. What formula should i used so instead 0:02:50 i wil get value = 170 ? Best Regards
0x Thank you
time.png / V - Attached On 2022-07-20 09:03:48 UTC - Size: 2.55 KB - 135 views

[2022-07-20 14:01:56] #2 [Go To First Post]
Sawtooth - Posts: 4285
What formula should i use so instead of 00:02:50 i will get value = 170 ? If you are using the Bar Time Duration study's output, try this: =MINUTE(ID1.SG1@3)*60 + SECOND(ID1.SG1@3) -where ID1 is the Bar Time Duration study.
1x Thank you

[Page 1 of 1] First Page -- 1 -- Last Page