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

3 Replies

# Re: Calculate percentage for specific IF criteria

With helper column and pivot table.

best response confirmed by Mollie523 (Copper Contributor)
Solution

# Re: Calculate percentage for specific IF criteria

@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

# Re: Calculate percentage for specific IF criteria

@Hans Vogelaar Thank you! That worked splendidly.