How to calculate times between a range with two conditions?
times 01.xlsx | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | start time | end time | how much times in range (00:00 - 07:00) | how much times in range (20:00 - 23:59) | how much times not in these two ranges | ||
2 | 3:00 | 21:00 | 4:00 | 1:00 | 13:00 | ||
3 | *formula1 | *formula2 | *formula3 | ||||
4 | |||||||
5 | *I need formulas for yellow parts | ||||||
Sheet1 |