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!
Solved
Convert duration (mm:ss) into seconds
+2Best answer by Sistema_Aotearo
Yeah, the solution is actually rather simple, yet strange!
Make a formula field with this:
{Duration} * 1The duration data is already stored in seconds. Multiplying it by 1 will display the seconds! Let me know if this works for you.
+20Yeah, the solution is actually rather simple, yet strange!
Make a formula field with this:
{Duration} * 1The duration data is already stored in seconds. Multiplying it by 1 will display the seconds! Let me know if this works for you.
Justin NgProgramme Coordinator at Sistema Aotearoahttps://www.sistemaaotearoa.org.nz/
+2Yeah, the solution is actually rather simple, yet strange!
Make a formula field with this:
{Duration} * 1The duration data is already stored in seconds. Multiplying it by 1 will display the seconds! Let me know if this works for you.
Thank you so much!!! This worked!
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.