doing math on the number before a decimal

How do I take the 1.15 and multiply the 1. x 16 and then add the .15 (should equal 31)?

and separately, then take the 31 outcome and divide by 24 (fps) to equal: 00:01:07 (H:M:S)

Cell A: 1.15
Cell B: 31 (output of 1.x16 +15)
Cell C: 31x24 in H:M:S

Thanks!
-Sam

The INT function will give you the integer part of A1, so you can multiply this by 16 and you can also use it to give you the fractional part of A1 (by subtraction), which can then be multiplied by 100 before adding it to the result of the first part.

Hope this helps.

Pete

Thanks, how do I set formulate it to read the .15 and then add that to the =INT(A1*16)?
Because the .15 will be different in other cells, do I have to first separate the 1.15 into two cells A1: 1.15 , (A2: 1 , B2: 15) and then add them up? (C2=A2+B2)?

Example:
A1: 4.06 (this should equal out to: 4x16+6 = 50)
A2: 1.13 (1x16+13 = 29)
A3: 2.00 (2x16+0= 32)
A4: 3.14 (3x16+14= 62)

Thanks for the help!

If the value is in cell A1, then you can use this formula in B1:

=INT(A1)*16 +(A1-INT(A1))*100

which is what I said in Post #2.

Hope this helps.

Pete

Try

=INT(A1)*16+MOD(A1,1)*100

Thank you shg, Peter_UK, JohnTopley !!!

And sorry Peter_UK that i misunderstood your first post, thank you for the clarification!

shg you rock!

- Sam