Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Convert Text to Number?

David Bright
David Bright ✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

Is there a way in a Smartsheet column to convert a Text value into a Numeric value?


For example, I have a column called "Duration", formatted as a "Text/Number" column type, and I have values in that column that are in the HH:MM:SS format, and look something like this: 00:15:00, 01:20:00, etc.


I'm trying to add a few of these together to calculate the "Total Duration", but there is not a simple way to do this in Smartsheet, so I am attempting to "dissassemble" each cell into parts, then add the parts together, and then "combine" the parts into the HH:MM:SS format.


So far I have been able to "dissassemble" the cell values into three new columns by using the LEFT(), MID(), and RIGHT() functions. This works, but when I do that the resulting cells contain text values not numerical values - which means that the SUM() function does not work.


Any ideas on how to convert the "deconstructed" cells into numerical values?


Thanks for the help!




This discussion has been closed.