I suspect I am being lazy by not spending a couple of hours learning about this myself and finding my own answers. But if there is anyone out there that can give me the answer on a plate I would be most grateful. A2 is the date. B2 is the work start time (on that date) and C2 is the work finish time (on the same date). Work never goes beyond 23:59 hrs. Rates of pay are (say) £10 per hour Mon-Fri 8AM to 8PM. £12 per hour for Saturday and Sundays and Public Holidays (except Christmas Day, Boxing day and New years day) and £20 per hour for all work on a Christmas day, boxing day and new years day. Any recommendation so that I can ultimately have cells that dispay the hours worked at the different rates and the total earned for that row?