Add time

[Nick1960]

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

[#2 · Accepted solution]

@Nick1960 

Let's say a start time is in cell D2.

In another cell, e.g. E2, enter the formula

=IF(MOD(D2,1)>TIME(21,30,0),INT(D2)+1+TIME(6,0,0),D2)

Format the cell with the formula with the desired date/time format.

[#3]

@Hans Vogelaar 

Hi Hans,

Thanks very much, works a treat. Much appreciated

Cheers