How do I move decimal one place to the left?

Ami Veltrie
Ami Veltrie ✭✭✭✭✭✭
edited 11/11/22 in Formulas and Functions

Formula for calculating minutes in military time but the decimal in the Minutes column is in the wrong place.

How do I edit the formula below to move the decimal one place to the left?

=(VALUE(LEFT([Clock Out (Military)]@row, IF(LEN([Clock Out (Military)]@row) = 3, 1, 2)) + (VALUE(RIGHT([Clock Out (Military)]@row, 2)) / 60)) - (VALUE(LEFT([Clock In (Military)]@row, IF(LEN([Clock In (Military)]@row) = 3, 1, 2)) + (VALUE(RIGHT([Clock In (Military)]@row, 2)) / 60)))) * 60


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!