
Frank_Arnold

6 - Interface Innovator
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Feb 04, 2018
01:45 AM
I have records for music tracks of an album, each with a own playtime field as text in the format “m:s”.
I know how to use a formula to convert this values to seconds and the “sum” shows also the correct values of all records in seconds but how can I display this sum value as a formatted text like “h:m:s” to have the complete runtime of all tracks in this collection?
Unfortunately the “sum” function doesn’t have a formatting option, so I need something different, but I have completely no idea how to do this.
5 Comments