Calculate holidays hours

highlander

New member
Joined
Jan 31, 2014
Messages
3
Reaction score
0
Points
0
Please, I need calculate the hours from 15 PM saturday to 6 AM monday by init and end.
Thanks and sorry for my english.
 

Attachments

  • Ejemplo.xlsx
    17.1 KB · Views: 16
You need to explain the data and how to calculate the results much more than that, we cannot read your mind.
 
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.
 
Back
Top