Forum Discussion

Mollie523's avatar
Mollie523
Copper Contributor
Jul 22, 2023
Solved

Calculate percentage for specific IF criteria

I'm trying to create a formula to calculate the percentage of all orders received between 06:00 - 14:00, between 14:00 - 22:00 and between 22:00 - 06:00.  All order received times are input in one column. I've tried a few different IF formulas and looked for answers, but I'm struggling.

Thank you

  • Mollie523 Let's say the times are in T2:T100.

    Use the following formulas and format the cells with the formulas as percentage:

     

    For example in Z1:

    =COUNTIFS(T2:T100,">="&TIME(6,0,0),T2:T100,"<"&TIME(14,0,0))/COUNT(T2:T100)

    In Z2:

    =COUNTIFS(T2:T100,">="&TIME(14,0,0),T2:T100,"<"&TIME(22,0,0))/COUNT(T2:T100)

    In Z3:

    =100%-Z1-Z2

3 Replies

Resources