Hi. I need help in my worksheet. I need formula to calculate working hours between two dates excluding day off which is saturday, lunch and breaks.
My working hours is from 8am-5pm
my 1st break is 10:00-10:15
2nd break 3pm-3:15
lunch break 12pm-1pm
Hello,
Not sure what you have tried with, if you can upload a sample file with some data it will be easier to give a correct and relevant answer. I will try to give some suggestions anyway. Do check the below links.
https://www.myonlinetraininghub.com/excel-networkdays-intl-function
https://www.myonlinetraininghub.com/excel-custom-number-format-guide#_Toc474757767
Thankyou, i’ll upload a sample later!
L.E:
End Date: 8-july 2019 10:00
I need formula calcuting work hours between two dates excluding 1 day off, lunch break, and breaks.
my work starts at 8am-5pm only
my 1st break is 10:00-10:15
my lunch break is 12:00-13:00
my 2nd break is 15:00-15:15
day off is sunday only.
THANKS!
In this sample, A2 is start date, B2 is end date. And C is the answer that i am looking for formula.
I need formula calcuting work hours between two dates excluding day off, lunch break, and breaks.
my work starts at 8am-5pm only
my 1st break is 10:00-10:15
my lunch break is 12:00-13:00
my 2nd break is 15:00-15:15
day off is sunday only.
if the answer in your formula is 9hours and 30 minutes, thats the formula that i am looking for.
Hi Dinah,
Please continue this topic, do not create new topics with replies to the same problem.
