Hi all,
could someone possibly help me please.
After i have worked out the formula, I want to get a bar chart/graph with the counts of the hours in the day when vehicles arrive to see what hours are the busiest hours.
For example..
Goods IN
01:00:00 to 01:59:59 = count of 2
02:00:00 to 02:59:59 = count of 4
Goods OUT
01:00:00 to 01:59:59 = count of 1
02:00:00 to 02:59:59 = count of 0
I need to do the above for both Goods IN and another for Goods OUT vehicles.
I am struggling to create the formula other than =COUNTIFS($B$2:$B$13,">="&F2,$B$2:$B$13,"<"&G2) for the attached file.
I know the format of times is wrong but wondered if it can also be picked up.
thank you
Stuio
Bookmarks