How to calculate delivery date taking account of tea break, lunch break, weekends and holidays?


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. 


Answer the Question

You must create an account to use the forum. Create an Account or Login