How to compute for elapsed time in days,hours and minutes based on the following conditions?
1. Break is constant 60 mins
2. On Same date, If start time and end time is before 12NN then break should not be deducted
3. On Same date, If start time and end time is after 1PM then break should not be deducted
4. On different dates, If end time is before 12NN then break should not be deducted
5. sample output 22d 5h 45m
On Sheet Time column A2-E2:
2/5/2024-3/7/2024
Start Time End Time Break hh:mm Total hh:mm
9:50 am 5:00 pm 1:00 6:10 ---- 2/5/2024
8:00 am 4:35 pm 1:00 7:35 ---- 3/7/2024
Total Time: 22d 5h 45m
Then, compute for the days in between 2/5/2024-3/7/2024 on the Weekends and Holidays Sheet excluding those
marked as weekend and holidays.
I have attached a sample excel sheet for your perusal.
Thank you.
Bookmarks