Converting string to duration field (text to secon...

[heyitsynzyy]

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!

[Sistema_Aotearo · Accepted solution]

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.

[heyitsynzyy]

Thank you so much!!! This worked!