Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count cases by Hour

I have 2 columns, CaseID and Referral Date. The Referral Date is a normal time format (MM/DD/YYYY HH:MM:SS AM/PM) and I am trying to count the CaseID by the hour they were referred.    How would I ...
Need Help
JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Can you give a sample of the data and your expected output? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    • JarroVGIT's avatar
      JarroVGIT
      Resident Rockstar
      6 years ago

      Please please please don't post pictures of data, typing over datetime values is the absolute no hobby of ours ğŸ˜‚

      Can you just copy paste from Excel into the textbox please? Thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Sorry about that. Does this work better?

         

        CaseTime
        A1231/1/2020 1:32
        B1761/2/2020 1:32
        C6751/3/2020 2:43
        D4451/4/2020 3:23
        E8761/5/2020 12:34