Hi guys,
I would like some help with regard to my excel requirement.
Within my excel I have a creation date in the following format 20/08/2014 and what I would like to calculate is the difference between it and the delivery date (same format) by number of hours. The issue I have is that there can be multiple delivery dates with the same ID and I would like to only calculate the difference between creation dates and first (most recent) delivery date.
The complex piece of this is that I would like to calculate the difference between the two dates in hours and also calculate the difference between the two dates using business hours. Business hours equals 09:00 - 17:30.
I have attached some sample data with some guidelines. If someone could help me on this is would be much appreciated.
Pitcher,
Andrew
I would like some help with regard to my excel requirement.
Within my excel I have a creation date in the following format 20/08/2014 and what I would like to calculate is the difference between it and the delivery date (same format) by number of hours. The issue I have is that there can be multiple delivery dates with the same ID and I would like to only calculate the difference between creation dates and first (most recent) delivery date.
The complex piece of this is that I would like to calculate the difference between the two dates in hours and also calculate the difference between the two dates using business hours. Business hours equals 09:00 - 17:30.
I have attached some sample data with some guidelines. If someone could help me on this is would be much appreciated.
Pitcher,
Andrew