答案1
这似乎很容易:
Event Start End Value
1 01/01/2015 10:00 01/01/2015 10:05 00:05:00 <- =C2-B2
2 01/01/2015 10:02 01/01/2015 10:07 00:05:00 <- =C3-B3
3 01/01/2015 10:10 01/01/2015 10:12 00:02:00 <- etc.
Total: 00:12:00 <- =SUM(D2:D4)