mynameisnotbob
New Member
- Joined
- Jun 22, 2019
- Messages
- 4
I have a sheet for the days of the week, and hours within the day. Every hour worked has a '1' in the corresponding cell. Every hour not worked is blank. I need to calculate the number of hours between worked hours.
<colgroup><col span="5"><col><col span="3"></colgroup><tbody>
</tbody>
What formula can I use to count the number of blank cells from the last "1" to the next "1" in consecutive hours.
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | |
0:00 | 1 | |||||||
1:00 | 1 | |||||||
2:00 | 1 | |||||||
3:00 | 1 | |||||||
4:00 | 1 | |||||||
5:00 | 1 | |||||||
6:00 | 1 | 1 | 1 | |||||
7:00 | 1 | 1 | 1 | |||||
8:00 | 1 | 1 | 1 | |||||
9:00 | 1 | 1 | 1 | |||||
10:00 | 1 | 1 | 1 | |||||
11:00 | 1 | 1 | 1 | |||||
12:00 | 1 | 1 | 1 | |||||
13:00 | 1 | 1 | 1 | |||||
14:00 | 1 | 1 | 1 | |||||
15:00 | 1 | 1 | 1 | |||||
16:00 | 1 | 1 | 1 | |||||
17:00 | 1 | 1 | 1 | |||||
18:00 | 1 | |||||||
19:00 | 1 | |||||||
20:00 | 1 | |||||||
21:00 | 1 | |||||||
22:00 | 1 | |||||||
23:00 | 1 | |||||||
30 | 36 | 24 | 48 |
<colgroup><col span="5"><col><col span="3"></colgroup><tbody>
</tbody>
What formula can I use to count the number of blank cells from the last "1" to the next "1" in consecutive hours.