Hi All,
I am trying to convert a table that looks like this:
Time; Event 1; Event 2
12:00; 0; 0
13:00 ; 0; 0
14:00 ; 10; 0
15:00 ; 4; 0
16:00 ; 5; 4
17:00 ; 3; 5
18:00 ; 5; 0
19:00 ; 0; 0
20:00 ; 0; 0
21:00; 0; 0
22:00 ; 0; 0
23:00 ; 1; 0
0:00 ; 2; 0
1:00 ; 20; 0
2:00; 0; 0
into something like this:
Events; Start time; End Time; Total
Event 1; 14:00 ; 18:00; 27
Event 1; 23:00 ; 1:00 ; 23
Event 2; 16:00; 17:00; 9
i.e. basically for every sequence an event that is non-zero, the starting time and end time is captured, and the sum of the event in this time period is calculated. Events can occur more than once for each event type (e.g. event 1 occurs twice in the time range given).
Any help would be much appreciated - excel amateur over here.
thanks,
learnex
I am trying to convert a table that looks like this:
Time; Event 1; Event 2
12:00; 0; 0
13:00 ; 0; 0
14:00 ; 10; 0
15:00 ; 4; 0
16:00 ; 5; 4
17:00 ; 3; 5
18:00 ; 5; 0
19:00 ; 0; 0
20:00 ; 0; 0
21:00; 0; 0
22:00 ; 0; 0
23:00 ; 1; 0
0:00 ; 2; 0
1:00 ; 20; 0
2:00; 0; 0
into something like this:
Events; Start time; End Time; Total
Event 1; 14:00 ; 18:00; 27
Event 1; 23:00 ; 1:00 ; 23
Event 2; 16:00; 17:00; 9
i.e. basically for every sequence an event that is non-zero, the starting time and end time is captured, and the sum of the event in this time period is calculated. Events can occur more than once for each event type (e.g. event 1 occurs twice in the time range given).
Any help would be much appreciated - excel amateur over here.
thanks,
learnex
