Thanks for the work,
The time solution is more elegant (and reliable) than my effort, something to remember. The countif formula is big isn't it :-), your effort is appreciated. Do you know if there is a way to have a formula that has the ability to automatically account for new/removed shifts e.g. should a 3 hour F3 shift be added (09:00-12:00).

Regards