Help

Convert duration (mm:ss) into seconds

Topic Labels: Formulas
Solved
Jump to Solution
509 2
cancel
Showing results for 
Search instead for 
Did you mean: 
heyitsynzyy
4 - Data Explorer
4 - Data Explorer

How do I convert a duration into seconds?

I would like a formula for the "Seconds" column that automatically calculates this. 

Understand this is probably so basic, but would appreciate any help. Thank you!

Screen Shot 2024-07-18 at 1.43.20 PM.png

1 Solution

Accepted Solutions

Yeah, the solution is actually rather simple, yet strange!

Make a formula field with this:

{Duration} * 1

The duration data is already stored in seconds. Multiplying it by 1 will display the seconds! Let me know if this works for you.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

See Solution in Thread

2 Replies 2

Yeah, the solution is actually rather simple, yet strange!

Make a formula field with this:

{Duration} * 1

The duration data is already stored in seconds. Multiplying it by 1 will display the seconds! Let me know if this works for you.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

Thank you so much!!! This worked!