5 Replies Latest reply on Sep 27, 2018 10:48 AM by Joe Oppelt

    Counting instances before a certain time of day

    Scott Kolar

      I want to see the average percentage of jobs completed before 2pm.

       

      So for example if 200 of 300 jobs were completed before 2pm in august and 100 of 250 jobs were completed in septebmer.  I want to plot 66.6% for august, and 40% for september. 

       

      Similar to this thread Less or more than a particular day and time but I just want to count before a certain time for all days of the month not a specific date.

       

      My attempt: SUM(IIF([Job Completed]<00:14:00, 1, 0))

       

      I attached the workbook to the thread.