Previous Topic Next Topic

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

Closed
sailingdemon Posts 11 Registration date Thursday September 28, 2017 Status Member Last seen November 13, 2017 - Nov 13, 2017 at 11:01 AM
sailingdemon Posts 11 Registration date Thursday September 28, 2017 Status Member Last seen November 13, 2017 - 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?
Related:

1 response

Answer 1 / 1
sailingdemon Posts 11 Registration date Thursday September 28, 2017 Status Member Last seen November 13, 2017
Nov 13, 2017 at 03:44 PM
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
0