200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Hi All,
I'm trying to calculate a production delivery date that account for tea&lunch break, weekends and holidays. I found a useful equation, attached in the post, but this equation doesn't take into account of the tea&lunch breaks. Could anyone help me with this?
My tea & lunch breaks are as follows:
10:00~10:15 Tea break
12:00~13:00 Lunch break
15:00~15:15 Afternoon tea break
Thanks in advance for all your help!!
I find working with decimals much easier than time. I use .25 for 15 minutes after hour; .50 for half past; and .75 for 45 min past. Combine with military time (add 12 to the hours past Noon, so 1:30 pm becomes 13.50; 4:45 pm becomes 16.75). If each and every day has the breaks you described above (2 tea breaks & Lunch) i would just subtract 1.5 hours from each day as breaks OR you would have to develop a formula based on ending time to look at what breaks would be included. Example 1 8:30 to 5:30pm would be 8.5 & 17.5 (17.5 - 8.5 = 9.0 take off breaks of 1.5 = 7.5 hours for the day. Example 2 8:30 to 3:00 pm (8.5 to 15.0 would be 15 - 8.5 = 6.5 less the 2 breaks of 1.25 = 5.25.
