Hello everyone,

I need to make a chart listing customer collections by the hour.

Column A would have varying amounts of customers each day.

Column B would have their booked collection times.

Column C would be used for the phrase "on time" to be entered if the collection is on time.

Column D would have a list of times e.g 09:00-10:00hrs, 10:00hrs-11:00hrs and so on.

Column E would need a formula to show percentage of "on time" collections by the hour relevant to the times in column D.

Hope some one can point me in the right direction please.