Hello, I need help creating Excel formulas that separates hours in a day by three different time periods. The time periods are:
· Period 1: 10 p.m. to 6 a.m. Everyday
· Period 2: 4 p.m. to 7 p.m. Mondaythrough Friday (except Federal Holidays)
· Period 3: 6 a.m. to 4 p.m. AND 7 p.m. to 10 p.m. Monday through Friday, and 6 a.m. to 10 p.m. on Saturday, Sunday and Federal Holidays
An Excel formula for each period is fine. Any help is greatly appreciated. Thanks!
· Period 1: 10 p.m. to 6 a.m. Everyday
· Period 2: 4 p.m. to 7 p.m. Mondaythrough Friday (except Federal Holidays)
· Period 3: 6 a.m. to 4 p.m. AND 7 p.m. to 10 p.m. Monday through Friday, and 6 a.m. to 10 p.m. on Saturday, Sunday and Federal Holidays
An Excel formula for each period is fine. Any help is greatly appreciated. Thanks!