Results 1 to 3 of 3

Thread: Calculate holidays hours

  1. #1

    Calculate holidays hours



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

    Please, I need calculate the hours from 15 PM saturday to 6 AM monday by init and end.
    Thanks and sorry for my english.
    Attached Files Attached Files

  2. #2
    You need to explain the data and how to calculate the results much more than that, we cannot read your mind.

  3. #3
    Thanks for your answer Bob and sorry.

    The festive hours counted from 15 PM hours on Saturday until 6 AM Monday. For example , Saturday initattion (cells INICIO E6:AI6) 14 PM to end (cells FINAL E7:AI7) 22 hours would be 7 hours festive (cells FESTIVAS E11:AI11). Initattion from 10 PM sunday to 6 AM monday, 8 hours festive. Saturdays from 15:00 to 0:00. Sundays from 0:00 to 0:00 and mondays 0:00 to 6:00.
    I hope I explained well.

Posting Permissions

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