# A leading zero is disrupting my formula.

Options

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.

• ✭✭✭✭✭✭
Options

wrap your reference with a value() and it should correct.

• Options

Thanks for the quick reply. I tried wrapping the formula with VALUE() and it lead to the same error

=VALUE(([(H) Hour]1 * 60 * 60) + ([(M) Minute]1 * 60) + [(S) Second]1)

• ✭✭✭✭✭✭
Options

=(value([(H) Hour]1) * 60 * 60) + (value([(M) Minute]1) * 60) + value([(S) Second]1)

• Options

That got it.

Thank you

-Cory

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!