Andrew Skibbz
New Member
- Joined
- Mar 29, 2017
- Messages
- 28
Hi All,
I need to know the time (hh:mm:ss) it has taken between two dates 'arrived date' and 'received date'.
- The arrived date is when an 'order' has been placed by the customer.
- The received date is when it was 'booked onto the system by us.
We have 24hrs to book an order into the system, so I want to see how long its is taking us to effectively process the order (arrived vs received)
The formula would need to include the following caveats:
1) If the arrived date and time falls on a Friday at 10am (e.g. 12/02/21 10:00:00) - (excluding the Weekend and Mondays) we would have until 10am the following Tuesday (16/02/21 10:00:00) to enter a 'received date'. This would count as 24hrs. not 4 days.
2) If the arrived date and time falls on a Friday which includes a Bank Holiday, then we would have until 10am the following Wednesday as the Tuesday would count as the Monday in this case.
What I eventually want to end up with is a bar chart which shows the time is has taken us (hh:mm:ss) between the two dates (e.g 0-6 hrs, 6-12 hrs, 12-18hrs, 18-24hrs).
I would very much appreciate your help on this please.
Regards,
Andrew
I need to know the time (hh:mm:ss) it has taken between two dates 'arrived date' and 'received date'.
- The arrived date is when an 'order' has been placed by the customer.
- The received date is when it was 'booked onto the system by us.
We have 24hrs to book an order into the system, so I want to see how long its is taking us to effectively process the order (arrived vs received)
The formula would need to include the following caveats:
1) If the arrived date and time falls on a Friday at 10am (e.g. 12/02/21 10:00:00) - (excluding the Weekend and Mondays) we would have until 10am the following Tuesday (16/02/21 10:00:00) to enter a 'received date'. This would count as 24hrs. not 4 days.
2) If the arrived date and time falls on a Friday which includes a Bank Holiday, then we would have until 10am the following Wednesday as the Tuesday would count as the Monday in this case.
What I eventually want to end up with is a bar chart which shows the time is has taken us (hh:mm:ss) between the two dates (e.g 0-6 hrs, 6-12 hrs, 12-18hrs, 18-24hrs).
I would very much appreciate your help on this please.
Regards,
Andrew