Timestamp If statement

[Pasteurized]

Hello,

I have data set that looks like 10/25/19 02:03:00 PM. I want to find a way to change another cell IF this cell's time is after 02:00:00 PM. Essentally, if the order was created after 2 PM, my pickup date (Column F) should be +1

data set looks like this Column D Create date
D1 Cell : Oct 1, 2019, 2:01:21 PM

Colum E :Order Ship Date :
E1 Cell : 10/2/2019

Column F Must pickup date
F1: 10/1/2019

 

[joshman108]

See if this works for you. You will need to put it in another column so it can operate on column F. Column F would need to stay as it is.

=if(VALUE(HOUR(d:d)&"."&MINUTE(d:d))>14,f:f+1,f:f)