- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 10:44 PM - edited ‎Jul 17, 2024 10:45 PM
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! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 11:09 PM
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/

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 17, 2024 11:09 PM
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/
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 18, 2024 06:37 PM
Thank you so much!!! This worked!
