Log In
Register
Home
Active Member
July 7, 2019
Offline
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
See Answer
VIP
Trusted Members
December 7, 2016
Offline
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.
Active Member
July 7, 2019
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
Hi Dinah,
Please continue this topic, do not create new topics with replies to the same problem.
Answers Post
1 Guest(s)
