Calculation based on decimal

C

cjborntorun

Please advised on how to calculate:

I have a forecast = 39,975
I have a shift qty = 7,535
shift production requirement = 5.3 (39975/7535)

What formula will determine the qty of the overage of .3 shifts?

Thank you
 
F

FSt1

hi
=mod(39975,7535)
or if 39975 was in a1 and 7535 was in b1 then
=mod(a1,b1)

Regards
FSt1
 
Top