How do I move decimal one place to the left?
Ami Veltrie
✭✭✭✭✭✭
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
Answers

You can move the decimal 1 place to the left by multiplying the number by 10.
Hope this helps!
Ray
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!