Support Board
Date/Time: Sun, 21 Dec 2025 18:47:57 +0000
Post From: Spreadsheet - formating to seconds
| [2022-07-20 14:01:56] |
| Sawtooth - Posts: 4300 |
|
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. |