Adding on call hours for different days

**Antennas** · 10-11-2011, 05:34 PM

I am trying to calculate on call hours. The problem is that from Sunday to Wednesday it is 5 hours and from Thur to Sat it i s 4 hours. I got it to add regular on call at 4 hours but can't seem to make it add in the 5 hour diff. I have so far this formula...
=COUNTIF(B4:Q4,"D-C")*4+COUNTIF(B1:Q4,"E-C")*4
The D-C is day on call and the E-C eve on call value.

Can anyone figure out a way to make it check to see if it's Sun to Wed and make it add 5 instead of four?

Thanks

**daddylonglegs** · 10-11-2011, 05:56 PM

So where are the days specified? Do you show dates or just text like "Sat" or 2Saturday"?

**Antennas** · 10-11-2011, 06:24 PM

Sorry I should have realized you would need that sorry. I will attach what I have so far.
The days are just listed in one row and the date in another.

**daddylonglegs** · 10-11-2011, 07:04 PM

Try this version for V4 copied down

=SUM(COUNTIFS(B4:Q4,{"D-C";"E-C"},B$1:Q$1,{"Su","Mo","Tu","We","Th","Fr","Sa"}&"*")*{5,5,5,5,4,4,4})

**Antennas** · 10-11-2011, 07:16 PM

Thanks very much I had not thought of doing it that way at all. Of course I am just learning these formulae though too. Thanks for the learning tip. I will dissect that code and see how it works.

Thanks again!!

Andrew