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?

Thanks

M

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!