mrexcelhelpsheet.xlsx

	A	B	C	D	F	H	J
1	Release No.	Type	Time	Adjusted Time
2	1001		12:00		All release numbers are unique, starting number is for days of the week e.g. 1### Monday,2### Tuesday, 3### Wednesday, etc
3	1003		12:15
4	1104		12:15
5	1099		18:00
6	1100		18:00		I have a count for the total releases =counta(C:C)-1 All of my formulas are calculated on entire colums due to constantly adding and deleting rows which was messing up formulas and conditional formatting
7	1101		0:15
8	1102		0:30
9	1103		0:45
10	1104		1:15		Total	Pre 6am	number of pre 6am on current day not next day
11	1105		1:15		121	36	number of pre 6am on current day not next day
12	1106		1:15
13	1107		1:30		I need the Pre 6am cell to count the number of releases up to 6am but not the release after. So in the table to the left there are 36 releases before 6am (in this case cells C2:C37. Times after that are after 6am on the current day which I need to not be counted even if the times shown are before 6am on that day
14	1135		1:30
15	1136		1:30
16	1137		1:45
17	1138		1:45
18	1139		1:45
19	1140		1:45
20	1141		1:45
21	1142		1:45
22	1143		2:15
23	1144		2:30
24	1145		2:30
25	1146		2:45
26	1147		2:45
27	1148		3:00
28	1149		3:00
29	1172		3:15
30	1173		3:15
31	1174		3:30
32	1175		3:30
33	1176		3:45
34	1177		3:45
35	1178		4:00
36	1179		4:30
37	1180		4:30
38	1181		11:00
39	1187		12:30
40	1188		12:45
41	1189		12:45
42	1190		13:15
43	1191		13:30
44	1192		14:00
45	1193		14:00
46	1194		14:00
47	1195		14:15
48	1196		14:45
49	1200		15:00
50	1201		15:00
51	1202		15:15
52
53	2001		12:00
54	2002		12:15
55	2003		12:15
56	2004		12:15
57	2005		12:15
58	2018		0:00
59	2048		12:30
60	2049		12:30
61	2050		12:30
62	2051		12:30
63	2052		12:30
64	2053		13:00
65	2054		13:00
66	2055		13:00
67	2056		13:00
68	2057		13:00
69	2098		13:00
70	2099		13:00
71	2100		18:00
72	2101		18:00
73	2102		18:00
74	2103		18:00
75	2104		18:00
76	2105		18:00
77	2106		0:00
78	2107		0:00
79	213		0:15
80	2132		0:15
81	2133		0:15
82	2134		0:30
83	2135		0:45
84	2136		0:45
85	2137		0:45
86	2138		1:00
87	2139		1:30
88	2140		1:30
89	2141		1:45
90	2142		1:45
91	2143		1:45
92	2144		1:45
93	2145		2:00
94	2168		2:00
95	2169		2:15
96	2170		2:15
97	2171		2:30
98	2172		2:30
99	2173		2:30
100	2174		2:45