Employee Schedule - Subtracting a 30 min lunch from a schedule 6 or more hours long

Ok. The trick I think is then to add a column for the days when people are off (maybe a tick box?), and then change the format from Time, to Number with 2 decimal places (ie 08:00 becomes 08.00). This allows you to calculate easily using 0.5 for a half hour, and gives you a lot of options for further use. Would this be any good? I'll knock you up a working copy if you like. Let me know.

That would be fantastic if you could!!