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

Ray Lindstrom

@Ami Veltrie,

You can move the decimal 1 place to the left by multiplying the number by 10.

Hope this helps!

-Ray