Juliaafreeman
New Member
- Joined
- Mar 26, 2021
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
This is the first time I'm posting on here, so hopefully I'm doing this right.
Here is what I am trying to achieve: I have cargo that is being delivered to a site. Once the cargo has been delivered we have 14 hours to unload the cargo with working hours being Monday - Friday 7:00 am - 5:30 pm (and holidays excluded). After the 14 hours we start being charged per hour for the additional time it takes to complete unloading the cargo. I am trying to figure out what the date and time from the arrival date is 14 working hours?
Here is an example below. The answer SHOULD be 10/29/2019 10:30 am. I have been googling this for DAYS and all I get is "how to use network days between two dates" but that's not what I need.
If anyone can help with this, it would be greatly appreciated.
Here is what I am trying to achieve: I have cargo that is being delivered to a site. Once the cargo has been delivered we have 14 hours to unload the cargo with working hours being Monday - Friday 7:00 am - 5:30 pm (and holidays excluded). After the 14 hours we start being charged per hour for the additional time it takes to complete unloading the cargo. I am trying to figure out what the date and time from the arrival date is 14 working hours?
Here is an example below. The answer SHOULD be 10/29/2019 10:30 am. I have been googling this for DAYS and all I get is "how to use network days between two dates" but that's not what I need.
If anyone can help with this, it would be greatly appreciated.