trigger times

[thesilkster]

Hi i have a simple spreadsheet attached that shows depart time and a trigger time that is 2 hours prior, this should feed a simple if statement to show if escalation is required i cannot make it work any help would be appreciated, i think it has something to do with the NOW () function being day and time

regards

 

[vletm]

Modify Cell C2 to = A2+B2-TIME(2;0;0)

 

[thesilkster]

have error on that pal

 

[vletm]

modify reds: time(0,2,0)

 

[thesilkster]

sorted it , not ; thanks