Excel query trying to count values

[graemespence1]

Hello there I have a excel spreadsheet that groups number of calls I get in a 15 min time range grouped by date.
The example below may be better at explaining.

Date Total Number
01/03/2016 10
Time Slot Number of calls
08:00 5
08:15 6

This will carry down for the month.
What I am looking at is a formula or simple way to find out how many calls I took by first Date then time and generate that in a table
Again example table I generate manually is

Date 08:00 08:15 08:30
01/03/16 5 5 3

I make these manually and it can take me ages to gather and count the data and i'm sure there is a easier way to sort this data out.
Thanks for any help you can provide.

[Tony Valko]

Can you post a SMALL sample file with about 20 rows worth of data so we can see how the data and table is structured?

[graemespence1]

01/03/2016 10
10:45 1
11:00 1
11:15 0
12:00 1
12:15 1
14:00 1
14:30 1
14:45 0
15:00 1
15:15 1
15:30 0
15:45 1
16:00 1
02/03/2016 8
09:15 1
10:45 1
12:30 1
12:45 2
13:00 1
13:15 1
13:30 1
03/03/2016 13
09:15 1
09:30 0
10:00 1
10:45 1
11:00 2
11:15 0
12:15 1
13:00 1
13:15 3
15:30 1
16:15 1
16:30 1
04/03/2016 13
09:00 1
09:15 0
10:30 1
10:45 1
11:00 1
13:00 1
13:15 1
14:00 2
14:15 0
14:30 1
14:45 1
15:00 0
16:00 1
16:15 1
16:30 1

[Tony Valko]

How does that look in the spreadsheet?

[graemespence1]

Column A has the Dates then the items for each date underneath.
Column B has the number of times we had calls on the time and total on the date
A B
01/03/16 19
08:15 6
08:30 7
09:00 6
02/03/16 5
08:00 3
10:00 2

Any time slots that do not show is because no calls were picked up or recieved.

[shukla.ankur281190]

Perhaps,

try

D1=IF(LARGE($A$1:$A$51,ROW(1:1))>1,LARGE($A$1:$A$51,ROW(1:1)),"") and drag down it will return dates in D column

E1=IFERROR(SMALL(OFFSET($A$1,MATCH($D1,$A$1:$A$51,0),,COUNTA($A$1:$A$51)-MATCH($D1,$A$1:$A$51,0)),COLUMNS($E1:E1)),"") and drag towards the cell for retrieving the time in columns.

Check the attached file hope this is what you looking for.