Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Calls taken After hours

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi IML

    The range of dates is B9 on down
    related times are C9 on down
    I think he is wanting the totals of any calls > 17:30 < 08:30 for any given day of the week...
    Sunday totals
    Monday totals
    Tuesday ect...

    I guess your formula edited for each day would be perfect?

    =SUMPRODUCT(((WEEKDAY(B2:B10))=2)*((C2:C10<"8:30"+0)+(C2:C10>"17:30"+0)))

    I haven't tried it yet, but am going to try to incorporate it into hiw worksheet unless you have any better solutions?

    Thanks,
    Tom

  2. #12
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    there may be better ways, but I'll stick with the orignal - noting the orignal caveat to be careful about only including non-blanks in the range.

    weekday on a blank evaluates to saturday (7), and a blank 0, will evaluate true as to being less than 8:30.


    [ This Message was edited by: IML on 2002-05-03 15:21 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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