Column A is Names, B is H for Holiday (Mental reminder column) I have column
C (Monday) as a time for a person to work. IE: 09.30 - 12.00.

The next column (D) I want to show how many hours that is as in 2.5 etc. Do
I use the Time function in C5 and if so what calculates it in D5 for
example?

There are (As you would expect) the rest of the week similarly shown with a
total at the end.

If a person works less than 5 hours they don't qualify for a 30min break so
I need to show the total in column Q as the weeks hours (Totals of D F H J L
N & P) less the various days breaks if they work under the 5 hours. (Shown
in C E G I K M O)

Occasionally some people work a few days under 5 hours and a few over and I
can't decide what function to use to show it all in the correct cells.

Can any kind soul assist please because I am going mad trying to figure it
out ;-) ?