• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting of Workhours between two dates except weekend and Public holidays

Status
Not open for further replies.
Q

qwer123

New Member
I want to count working hours only between two different dates but I have weird condition as I want to count "9 hours" as per day between Monday to Thursday and 4hours every Friday.
Saturday and Sunday are non working days + calendar holidays. I'm super stressed and I did not find solution even I watch all youtube and google so much.. can someone rescue me please? attached excel sheet. Thanks in advance. God Bless you!!
 

Attachments

  • Annual Leave Tracker 2024.xlsx
    19.8 KB · Views: 3
Last edited:

qwer123​

Please do not duplicate ... actually, You had posted same to three different threads.
Continue with below one.

Count hours (9hrs per day Mon-Thursday) 4 hours every Friday between dates

I want to count working hours only between two different dates but I have weird condition as I want to count "9 hours" as per day between Monday to Thursday and 4hours every Friday. Saturday and Sunday are non working days + calendar holidays. I'm super stressed and I did not find solution even...
chandoo.org
 
Status
Not open for further replies.
Back
Top