sumif based on time.

[CPTN2469]

good afternoon, this is my first post on here and hoping i have come to the right spot. i have been searching for weeks without coming up with an answer that works for me. I work as a manager for ports in long beach california and we track move counts in an excel document by the hours. we break down the day into 4 periods of 2 hours a piece. in an attempt to make my life easier i have been trying to come up with a formula to use that i can just punch in the numbers and based off of the time they will go into a certain box. i do not have any idea if this is possible and i am open to other ideas as well. i have a cheap work around right now that is okay but trying to make it even easier. i will attempt to attach pictures to show what i am looking at and hopefully someone can help me out.

i have attached a copy of an example of a day. i would like to be able to just punch in the totals in the right hand side and based on the time (labeled at the top) it put in the difference there. so for example if i punch in at 1000 hours 60 i want it to go into the box for period 1 between the times of 0800 and 1000 hours. but then if at lets say 1130 i punch in 125 i want the difference of period 1 and that total to go into period 2 as it is in between those hours. so it would input 65 in period 2 cell.

	Period 1	Period 2	Lunch	Period 3	Period 4	OT 1	OT 2
CRANE	0800-1000	1000-1200	1200-1300	1300-1500	1500-1700			TOTAL	To Go
6	52	45		49				146	116
5	43	52		41				136	156
4	52	53		44				149	101
3	51	53		63				167	122
2	44	35		58				137	115
	38							38	200
									0
									0
MOVES	280	238		255				773
GANG HOURS	12.0	10.0	0.0	10.0	0.0	0.0	0.0	32.0
DETENTIONS								0.0
NET MPH	23.3	23.8	#DIV/0!	25.5	#DIV/0!	#DIV/0!	#DIV/0!	24.2
GROSS MPH	23.3	23.8	#DIV/0!	25.5	#DIV/0!	#DIV/0!	#DIV/0!	24.2
SHIP GROSS MPH	24.2						period 1 period 2 period 3 period 4 52 97 146 43 95 136 52 105 149 51 104 167 44 79 137 38 38 38 <tbody> </tbody> the way i have it set up now is that i have a seperate chart where i type in the total counts and basically period 1 = its box in its entirity. where as when i type in 97 for period 2 on 45 goes into the box in the original document that i use to send emails in. I hope this makes sense. I know the very basics of excell and am trying to learn more as we use it daily and formulas would make things a lot easier at my work. Thank you all for your time and please feel free to ask any follow up questions if needed. the above examples do corrilate with how i have it set up thank you

<tbody>
</tbody>

 

[CPTN2469]

i forgot to add the way that i have it now, if i do not have a number entered into the the period 2, 3, 4 it shows a - number which then affects the total counts on the top excel document. if i can not do it based off of time. is there a way to do a sumif and on show a number in the top cell if there is a number greater than 0 in the bottom chart?

for example i put 38 in cell a10 in the bottom chart on the top chart it goes into cell a1 as 38. but in cell b1 it will say -38 because the formula is cell b10-a10 for cell b1. i hope this makes sense. i am not good at this excel stuff and trying to learn it on my own is proving difficult.