Support Board
Date/Time: Wed, 18 Jun 2025 22:43:04 +0000
Post From: Spreadsheet - formating to seconds
| [2022-07-20 14:01:56] |
| Sawtooth - Posts: 4229 |
|
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. |