Hi PFDave, thanks for the reply.

Basically, it's for me to create a schedule of activities for planning work. So I would only want to use the hours of 08:00-12:00 & 13:00-17:00 of each workday (Mon-Fri).

Some examples...

Start: 16/11/16 08:00 Duration: 06:00 End: 17/11/16 15:00
The duration is 6 hours which when added to the start would equal 14:00 as the end date, but I don't want to include the hour between 12:00 & 13:00, leaving only 8 hours with the remainder being completed after 13:00.

Start: 16/11/16 08:00 Duration: 09:00 End: 17/11/16 09:00
There are 9 hours between 08:00 & 17:00 which is equal to the duration, but I don't want to include the hour between 12:00 & 13:00, leaving only 8 hours with the remainder being completed the first hour of the next workday.

Start: 18/11/16 14:00 Duration: 05:00 End: 20/11/16 10:00
The start date is a friday at 14:00 with a 5 hour duration. 3 hours remaining of the day, with the final 2 hours completed on the next workday (Monday).


As I've written that I realise it's more complicated than I first thought and am starting to see all kinds of trim, workday and if formulas.

Hopefully I've not just made it more unclear!