Calculation based on decimal
hi
=mod(39975,7535)
or if 39975 was in a1 and 7535 was in b1 then
=mod(a1,b1)
Regards
FSt1
"cjborntorun" wrote:
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
|