Hi all,

Does anyone know how I would go about the following...

If in cell A1, I have a date/time value of: 16/11/16 10:00
If in cell B1, I have an hours value of: 08:00

I can add the hours to the date/time by doing A1+B1 which will return the value of 16/11/16 18:00

What if I wanted to set a time limit so I could only add hours up to 17:00 of any given day, and then recommence at 08:00 the following day?

i.e... in the example above, I'm trying to add 8 hours but there is only 7 available up to 17:00 so the remaining 1 would be added to the following day resulting in a value of 16/11/16 09:00

I'm sure it's possible but not sure how to go about it.

Many thanks,

Jason