A leading zero is disrupting my formula.

Cory Bush

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.

L_123

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

Cory Bush

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)

L_123

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

Cory Bush

That got it.

Thank you

-Cory