Summing up time in the format HOURS:MINS:SECS

Hi All,

I have a list of tasks with estimated time of duration in the format Hours : Mins : Secs

I am looking to sum up the total of all tasks however I do not think Smartsheet likes to sum up values that have a semi colon breaking up the number. Is there a way around adding these up?

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!