• 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.

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

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

Thanks Belleke. If there will be no Friday will it will still do -5. I don't know if it works! I want a conditional formula that applies as count everyday 9hours (Mon - Thursday) and count 4 hours every Friday - Days should be detected automatically. for example if there is 2 Fridays then 4 hours each Friday should be automatically counted.
 

Attachments

Last edited:
Guys you are the besssssssssssssssssssssssssssst!! You have make my day and life easy!! Stay always best.... EXPERTS!!!
 
Back
Top