Support Board
Date/Time: Sat, 15 Mar 2025 15:18:26 +0000
Post From: Spreadsheet - formating to seconds
| [2022-07-20 14:01:56] |
| Sawtooth - Posts: 4183 |
|
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. |