Calculation based on decimal
 

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

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

Calculation based on decimal
 

thank you - that does the job

"FSt1" wrote:

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

Calculation based on decimal
 

glad to help. thanks for the feedback.

regards
FSt1

"cjborntorun" wrote:

thank you - that does the job

"FSt1" wrote:

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