How can I convert a time duration in time stamp format to a single integer representing seconds?
user015090
⚪️
I have a data set that has a column for call duration. It is in "timestamp" format. For example, a 16 minutes and 35 seconds duration shows up as 0:16:35. Is there a way to convert this column to a single integer representing the number of seconds. For example, in this case I would need 0:16:35 to be 995. Is this possible to do within the magic etl environment? I would like for this method to be reproducible for other users that may not necessarily be expert coders.
0
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部