filippo_87
New Member
- Joined
- Jan 21, 2018
- Messages
- 3
Hi all,
I work for an e-retailer and we are currently building up our KPIs dashboard. One of these, is the order lead-time. I will need to know how long it takes (IN HOURS, NOT IN DAYS) for my OPS team to dispatch an order. This calculation is based on a 24 hours working schedule. I will need to exclude weekends from the calculation. Below the involved data in my hands. Anybody can help on this please?
<colgroup><col><col></colgroup><tbody>
</tbody>
I work for an e-retailer and we are currently building up our KPIs dashboard. One of these, is the order lead-time. I will need to know how long it takes (IN HOURS, NOT IN DAYS) for my OPS team to dispatch an order. This calculation is based on a 24 hours working schedule. I will need to exclude weekends from the calculation. Below the involved data in my hands. Anybody can help on this please?
Order received into the system on | Order dispatched on |
27-11-2017 17:10:17 | 29-11-2017 15:23:14 |
<colgroup><col><col></colgroup><tbody>
</tbody>