How do you truncate 2.22 to just 0.22?

[Crackles McFarly]

Say I have a list of cells with numbers, some even some odd and some
with trailing decimals like so.
2
2.33
2.833
2.99
3
3.5
4
4.22

How can I get rid of the WHOLE number ? I need to manipulate the part
that is not the whole number.
thnx

 

[andycat]

You want the modulus. If the number, e.g. 4.22, is in cell A1, use
=MOD(a1,1)

 

[Mark Lincoln]

Here's another way:

=A1-TRUNC(A1)

Mark Lincoln

 

[Crackles McFarly]

Here's another way:

=A1-TRUNC(A1)

Mark Lincoln

=ROUNDDOWN(60*ROUNDDOWN(C15,8)-(D15*60),0)

C15=TOTAL # OF MINS [EVEN ONES >60 MINS]
This gave me a whole number. If it was under 1 [=0] then it was under
one hour and starlight minutes, it rounded down and then rounded down
a number that was multiplied by 60 which is the upper limit in minutes
of one hour..

omg