JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
Hi,
The hour range is between store open times (Monday - Friday 09:00 till 17:00)
If an order is placed we have a time of 6 hours to ship out the order.
Example:
An order is recieved Monday at 09:53, it has to be completed by 16:00
09:53 rounds up to 10:00 + 6 hours
Though if an order is placed at 15:30 it has to be fulfilled by 14:00 the next day
15:30 rounds to 16:00
16:00 - 17:00 = 1hour
next day 09:00 - 14:00 = 5 hours
As there is no work on a weekend, orders recieved friday after 11pm have to be fulfiled monday.
<tbody>
</tbody>
The red is what i need to calculate from the order date/time, i dont know how to go about this
Appreciate any help
The hour range is between store open times (Monday - Friday 09:00 till 17:00)
If an order is placed we have a time of 6 hours to ship out the order.
Example:
An order is recieved Monday at 09:53, it has to be completed by 16:00
09:53 rounds up to 10:00 + 6 hours
Though if an order is placed at 15:30 it has to be fulfilled by 14:00 the next day
15:30 rounds to 16:00
16:00 - 17:00 = 1hour
next day 09:00 - 14:00 = 5 hours
As there is no work on a weekend, orders recieved friday after 11pm have to be fulfiled monday.
Order Date | Order Time | Fulfil Date | Fulfil Time |
Thursday 14th Dec | 10:41 | Thursday 14th Dec | 17:00 |
Thursday 14th Dec | 13:01 | Friday 15th Dec | 12:00 |
Friday 15th Dec | 14:29 | Monday 18th Dec | 13:00 |
<tbody>
</tbody>
The red is what i need to calculate from the order date/time, i dont know how to go about this
Appreciate any help