Counting per hour in a report

[Tompanilla]

Hi!

I get daily a report showing how many pickups our company has to do, but I want Excel to count per hour how many they are. So far I do this manually, but I suppose there is a way to get Excel to count them for me.
The report looks like this:
Column A:¨
08:11
08:21
08:27
aso.

If Excel chcks column A it should find that there are for example 15b pickups between the hour of 08:00 and 08:59.

Could someone give me a clue? Thanks!

Thomas

 

[Akashwani]

Hi Thomas,

Do you mean something like this?....

Excel Workbook
	A	B	C	D	E
1	Pick Up Times	*	From	To	Count
2	08:12	*	08:00	08:59	4
3	08:23	*	09:00	09:59	3
4	08:42	*	10:00	10:59	2
5	08:57	*	11:00	11:59	0
6	09:00	*	*	*	*
7	09:05	*	*	*	*
8	09:55	*	*	*	*
9	10:00	*	*	*	*
10	10:12	*	*	*	*
Sheet1

I hope that helps.

Ak

 

[Tompanilla]

Thank you very much, this solved my problem very easily.

Brgds
Thomas

 

[Akashwani]

You are welcome Thomas, thanks for the feed back.

Ak

 

[SydneyGeek]

You could also use a pivot table. As long as there are no blanks or text values in the Time column you can group that on hours and get a delivery count without using formulas.

Denis