Formula to account for skids of boxes being emptied then refilled

so I need some Help. I am trying to make an Hour by Hour Box count Tracking spread sheet

total number of boxes on skid are 24, so one hour we could have 17 boxes on the skid then the next hour we had to get a new skid and there are now 4 boxes on the skid. so total in one hour -I have produced 24-17 = 7 on one skid and the other skid has only 4 boxes from that hour . for a total 0f 11 boxes produced

how do I make that formula, I want "boxes produced" to calculate automaticly and "boxes on skid" will be what is imputed each hour

hour_________boxes on skid________boxes produced
start with =___14
07-08 =______1__________________11
08-09 =______10_________________9
09-10 =______21_________________11
10-11 =______5__________________9
11-12 =______15_________________10
12-1p =______2__________________11
1p-2p =______14_________________12


- If the consecutive "boxes on skid" number is 10 then 10, do you assume that 0 boxes were produced, or that 24 boxes were produced? in this case 0 boxes were produced, because at 100% we can only produce a maximum of 14 boxes an hour

- If the consecutive "boxes on skid" number is 10 then 11, do you assume that 1 box was produced, or that 25 were produced? 1 box because at 100% we can only produce a maximum of 14 boxes an hour

- If the consecutive "boxes on skid" number is 10 then 9, do you assume that 23 boxes were produced, or that 47 were produced? this would never happen at 100% we can only produce a maximum of 14 boxes an hour

Welcome to the Forum les0341! Please take the time to review our rules. There aren't many, and they are all important. Rule #1 is to have a good thread title that will allow people to look at the list of threads and determine which ones they are able to answer. In a forum about "Formulas & Functions", virtually every question is about a "calculation problem." You would get the best response by changing your title to one more specific to your problem, such as "Formula to account for skids of boxes being emptied then refilled" or something similar.

While you are thinking about the title, please consider these questions:

- If the consecutive "boxes on skid" number is 10 then 10, do you assume that 0 boxes were produced, or that 24 boxes were produced?
- If the consecutive "boxes on skid" number is 10 then 11, do you assume that 1 box was produced, or that 25 were produced?
- If the consecutive "boxes on skid" number is 10 then 9, do you assume that 23 boxes were produced, or that 47 were produced?


Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

=if(b2="",0,if(b2<b1,24-b1+b2,b2-b1))

=if(b2="",0,b2-b1+if(b2<b1,24,0))

That was weird. My entire post was converted to lower case when I hit Save....Still works just the same.