Formula Help

I need to calculate a formula that:

If Cell 1A is 6870 and cell 2A Is 7212 the difference in cell 3A 342

342 then needs to be divided by 60 and then 6.0 added which is 5.7

then add 6.0 which is 11.7.

then multiply the .7 by .6 not changing the 11

which would be 11.42 which is acutally a time of the day.

Now if the number in cell 3A winds up being more than 600. I would need to subtract 600. and if so I would not add 6.0 I would add 18.

The formula I need is for production shipping.

The numbers in Cell 1A and 2A are the end and start of production and 3A is the difference. Only 60 items can be produced in an hour and only 600 per shift.

Shifts start a 6:00am and 18:00pm.

If anyone has any good ideas I would be most appreciative. I have a form for this I just dont know how to calculate the formulas correctly

Katie

Katie,

In cell A3 try:

=IF(A2-A1>600,A2-A1-600,A2-A1)

Then your in your destination cell you would have something like:

=FLOOR(A3/60+IF(A2-A1>600,18,6),1)*0.4+(A3/60+IF(A2-A1>600,18,6))*0.6

This should help some. If nothing else, the =Floor() function could help you.

I hope this helps.

-Jeff