Give a response by comparing 2 times (in different columns)

sailingdemon 11 Posts Thursday September 28, 2017Registration date November 13, 2017 Last seen - Nov 13, 2017 at 11:01 AM - Latest reply: sailingdemon 11 Posts Thursday September 28, 2017Registration date November 13, 2017 Last seen
- Nov 13, 2017 at 03:44 PM
I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours (7 AM until 1 AM).
Between 1 AM and 6 AM our response time has an additional 1.5 hours travelling time.

I am trying to extract data which shows whether or not we have achieved these time frames as a percentage and highlighting those jobs we do not manage to meet within time.

I have tried using the decimal value of a time but have found these to be unreliable as several different decimal values for the same time are shown.

Any ideas anyone please?
See more 

Your reply

1 reply

sailingdemon 11 Posts Thursday September 28, 2017Registration date November 13, 2017 Last seen - Nov 13, 2017 at 03:44 PM
0
Thank you
Played around some more and found this that works a treat:
=IF(AND(A1>=TIME(1,0,0),A1>=TIME(7,0,0)),"Yes","No")

Thanks anyway
Respond to sailingdemon