Report

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

Ask a question sailingdemon 11Posts Thursday September 28, 2017Registration date November 13, 2017 Last seen - Last answered on Nov 13, 2017 at 03:44 PM by sailingdemon
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?
Helpful
+0
plus moins
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
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!