Hi,

I have a load of stats reported in half hourly intervals that I need to
transfer into hourly information- sounds easy but I'm struggling!

Data is in the following format:


Time span # Calls Time span # Calls

00:00-00:30 5 00:00- 01:00 ?
00:31- 01:00 10 01:01- 02:00 ?
01:01- 01:30 2 02:01- 03:00 ?
01:31-02:00 22 03:01-04:00
?
02:01-02:30 44 04:01-05:00
?
02:31-03:00 1
03:01-03:30 15
03:31-04:00 12
04:01-04:30 62
04:31-05:00 7

Basically I need to populate the cells on the right marked with a ? with the
sum of the corresponding half hourly cells on the left- I have 12 months data
to work through.... any ideas??

Cheers