YourExcellency
New Member
- Joined
- Dec 6, 2022
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
I need to calculate estimated completion date for various projects. However, I need to subtract lunch breaks, and Sundays so that the formula works correctly. The work continues 24 hours (from 00:00 to 24:00) with three lunch breaks (each 1 hour). Lunch breaks are 03:30 - 04:30; 11:30 - 12:30; 19:00 - 20:00. I am using the formula below; Workday.Intl(C4-1;1+INT(F4/H4/21);11)+MOD(C4;1)+(F4-INT(F4/H4/21)*21*H4)/H4/21;""). However, it always shows an approximate time. I need the date to show me the exact time and minute of the Estimated Finishing time. Any help is much appreciated.