View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cjborntorun cjborntorun is offline
external usenet poster
 
Posts: 6
Default 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