Parsing Data based on multiple criterias

[rjshadowface]

I have huge amount of raw data in excel 2010 spreadsheet and I must filter it in order to make some reports from it. So far I made some of the filtering but hit a rock when I had to compare multiple values based on multiple criteria.

Here is how the part of the raw data locks like:

Column A	Column B	Column C	Column D	Column E
Server Name	Backup Date	Start Time	Elapsed Time	Backup Size
Server 1	05.04.2012	18:00:00	00:30:00	100 MB
Server 1	05.04.2012	18:10:00	00:50:00	50 MB
Server 2	05.04.2012	18:30:00	00:15:00	75 MB
Server 2	05.04.2012	18:15:00	00:30:00	110 MB
Server 1	06.04.2012	00:15:00	01:00:00	1000 MB
Server 2	06.04.2012	18:30:00	00:15:00	50 MB
Server 2	06.04.2012	18:15:00	00:20:00	115 MB
Server 1	06.04.2012	18:00:00	00:25:00	100 MB

Here is what I have to provide:

Backup sessions that are running within 1-2 hours period can be considered as running simultaneously so there time can be calculated as follows:
(The Largest Start Time + Corresponding Elapsed Time) - Smallest Start Time = Backup Time Interval

So for Every Date such Time Interval I have to provide. Like This:

Column A	Column B	Column C
Backup Date	Backup Size	Backup Time
05.04.2012	335 MB	01:00:00
06.04.2012	1265 MB	01:45:00

Backup Size for 05.04 is a SUM of all backup sizes for 05.04 that i have calculated with "sumifs" like this:

SUMIFS(
'RAW Data'!E:E;
'RAW Data'!A:A;"Server 1";
'RAW Data'!B:B;"05.04.2012";
)

But following part I cannot figure it out:

Backup Time for 05.04 is = (18:10:00 + 00:50:00) = 19:00:00 so 19:00:00 - 18:00:00 = 01:00:00 or 60 min. with is largest time interval (example: 18:10:00 - 19:00:00 > 18:00:00 - 18:30:00 or 18:30:00 - 18:45:00)
Backup Time for 06.04 is = ((((00:15:00 + 01:00:00) = 01:15:00) - 00:15:00) = 01:00:00) + ((((18:30:00 + 00:45:00) = 18:45:00) - 18:00:00) = 00:45:00) = 01:45:00