A leading zero is disrupting my formula.


I have a form that is asking for time. In order to calculate it I break the minutes and seconds out. It is often resulting in answers with a zero in front. This disrupts the formula listed here, =([(H) Hour]1 * 60 * 60) + ([(M) Minute]1 * 60) + [(S) Second]1.

We have many operators and have instructed them to stop putting the leading 0 into the form, but it has not stopped. I am now looking at ways to change my formula or have Smartsheet take the 0 off.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!