Results 1 to 3 of 3

Thread: Working Hours

  1. #1

    Working Hours



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i need formula for accounting working hours on Sundays in a month.for example if employees worked 3 times in the month.formula must multiply 7.5*3

    i hope i can explain.
    Attached Files Attached Files

  2. #2
    Acolyte CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    64
    Articles
    0
    Hi,

    In cell AL5 paste:

    Code:
    =SUMPRODUCT(--(WEEKDAY($D$4:$AG$4,1)=1),D5:AG5)
    and autofill down.

  3. #3


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by CheshireCat View Post
    Hi,

    In cell AL5 paste:

    Code:
    =SUMPRODUCT(--(WEEKDAY($D$4:$AG$4,1)=1),D5:AG5)
    and autofill down.
    thank you so much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •