Calculation based on decimal

[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

 

[FSt1]

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

Regards
FSt1

 

[cjborntorun]

thank you - that does the job

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

Regards
FSt1

 

[FSt1]

glad to help. thanks for the feedback.

regards
FSt1