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
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    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