Hello,
I work for a Transport company. We send notification to our customers as to when we will be delivering with a given window of 2.5 hours.
Our planned delivery date/time is (G3) 05/05/15 08:19
Our start window for this is (H3) 05/05/15 07:49
Our end window for this is (I3) 05/05/15 10:19
We actually arrived at (F3) 05/05/15 09:25
I would like a formula to show in cell (J3) 'IN TIME' if it is within this window.
I was thinking it was =IF(F3>=H3 and <=I3,"In Time","Late"), doesn't like it though. I've played with a few variations, but I cant think of another way round.
I work for a Transport company. We send notification to our customers as to when we will be delivering with a given window of 2.5 hours.
Our planned delivery date/time is (G3) 05/05/15 08:19
Our start window for this is (H3) 05/05/15 07:49
Our end window for this is (I3) 05/05/15 10:19
We actually arrived at (F3) 05/05/15 09:25
I would like a formula to show in cell (J3) 'IN TIME' if it is within this window.
I was thinking it was =IF(F3>=H3 and <=I3,"In Time","Late"), doesn't like it though. I've played with a few variations, but I cant think of another way round.
Last edited:
