I am trying to work out a formula to add Time to a time if it is later than a set time.
for example: If a job is going to start at or after 21:30 I need to move the start time to 06:00 the following day.
any help would be much appreciated
View best response
Let's say a start time is in cell D2.
In another cell, e.g. E2, enter the formula
Format the cell with the formula with the desired date/time format.
Thanks very much, works a treat. Much appreciated