yes it does, thanks, but it then throws up another small issue. Without getting too technical and boring, the ‘hours’ column is recording how many hours are available to work that day/week (which is the total i was referring to).
Next to it I have start time and then finish time using a time format, i.e. start= 7:00 finish=17:00, then I have a cell that works out how many hours that is for the day total=10:00. This last column then adds up the actual hours worked in a week and then the month and then shows me how many hours overtime are owed.
If I have one cell formatted just as a number for total available hours and another which is formatted as time showing actual hours, how do I structure a subtraction formula so that it shows the difference in hours?