Convert duration in a number column to make calculations


How could I covert the duration information/data in number so I can calculate variances in numbers or in percentages? I had to create a column and type each number, but I can not do that in 50 different worksheets.

Is there any formula that can convert the duration days in real numbers so I can use it for additional claulations?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!