Summarizing interval data

[Turf03]

I have a table that has data by date by interval. I would like to create an alternate table that is a sum total of each interval for the day.

What is the formula to get the total sum of each interval by day?

Date	Interval	Amount
1/1/2020	00:00	5
1/1/2020	00:30	15
1/1/2020	01:00	16
1/1/2020	01:30	20
1/1/2020	02:00	7

Total for 1/1/2020 is 63

[FrankAT · Accepted solution]

Hi @Turf03 

is this what you are looking for:

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)