Adding time durations as actual numbers

Options
dchouston
dchouston ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello,

We're trying to use Smartsheet to report on music details.  It would be very useful to take the durations of music tracks (formatted either as mm:ss or h:mm:ss) and add them together together for a total duration.   How would we attempt this?

 

Smartsheet sample.PNG

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!