andrew_milonavic
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 98
Hi Everyone,
How can I calculate the date/time a project will be completed based on a 30 hour project, 6am start, 8 hour shifts (assume breaks have been subtracted and will be working weekends)? The end date is easy but I cannot seem to get the end time right.
Example below
Any help would be great!
Thanks
Andrew
How can I calculate the date/time a project will be completed based on a 30 hour project, 6am start, 8 hour shifts (assume breaks have been subtracted and will be working weekends)? The end date is easy but I cannot seem to get the end time right.
Example below
Any help would be great!
Thanks
Andrew
A | B | C | D | F | G |
---|---|---|---|---|---|
Project Duration (Hours) | Start Date | Start Time | Shift Duration (Hours) | End Date | End Time |
30 | 1/21/2020 | 6:00 AM | 8 | ||