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?
plus moins
Played around some more and found this that works a treat:

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!