I have looked through some of the other questions on here and can't seem to find the answer so hope someone can help me, there is probably a simple fix to my issue and I am showing my limited knowledge regarding the functionality of excel.
I have a 24/7 roster that I would like to automatically show any gaps, currently this is done manually and is a painstaking task. An example of what a week would look like is below. The lines with the word SPARE can be ignored. Would there be a formula I could use to show the gaps between shifts in the bottom line? For example I can see that there is a 1545 to 2230 gap on the Sunday, but I currently would manually enter this.
<tbody>
</tbody>
I have a 24/7 roster that I would like to automatically show any gaps, currently this is done manually and is a painstaking task. An example of what a week would look like is below. The lines with the word SPARE can be ignored. Would there be a formula I could use to show the gaps between shifts in the bottom line? For example I can see that there is a 1545 to 2230 gap on the Sunday, but I currently would manually enter this.
w/c 22/09/2019 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | |||||||
START | FINISH | START | FINISH | START | FINISH | START | FINISH | START | FINISH | START | FINISH | START | FINISH | |
NAME | 07:00 | 15:45 | 07:00 | 15:45 | 07:00 | 15:45 | 07:00 | 15:45 | ||||||
22:30 | 07:15 | 22:30 | 07:15 | 22:30 | 07:15 | 22:30 | 07:15 | |||||||
SPARE | SPARE | SPARE | SPARE | |||||||||||
07:00 | 15:45 | 07:00 | 15:45 | 07:00 | 15:45 | 07:00 | 15:45 | 07:00 | 15:45 | |||||
22:30 | 07:15 | 22:30 | 07:15 | 22:30 | 07:15 | 22:30 | 07:15 | |||||||
14:00 | 22:45 | 14:00 | 22:45 | 14:00 | 22:45 | 14:00 | 22:45 | |||||||
07:30 | 13:15 | 07:30 | 13:15 | 11:15 | 17:45 | OFF | ||||||||
17:30 | 22:45 | 17:30 | 22:45 | 10:00 | 15:30 | |||||||||
GAPS: | ||||||||||||||
<tbody>
</tbody>