Results 1 to 5 of 5

Adding on call hours for different days

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    3

    Adding on call hours for different days

    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
    Last edited by Antennas; 10-11-2011 at 07:59 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1