mod(186,6) return 6, not 0

[borntobe]

Hi,
I used mod function to get remainder for 246.

=IF($M2<>0,IF($M2>60,$M2+IF(MOD($M2-60,6)>0,6,0),60),0)

I used above formula in column N.
Column M has formula too.

If M2 has bigger than 60, then minus 60, and then divide by 6.
IF remainder exist, then add 6, or add 0.

M2 was 246, and N2 got 252. But I expect 246.
What is wrong?

Thanks.

 

[borntobe]

Oh my! I got it. I got 246!
Thank you so much!!

 

[borntobe]

 

[Jonmo1]

You're welcome.

 

[Jonmo1]

You might be better off in the long run doing that round in the formula in M2.