Calculate percentage for specific IF criteria

[Mollie523]

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

[#2]

@Mollie523 

With helper column and pivot table.

[#3 · Accepted solution]

@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

[#4]

@Hans Vogelaar Thank you! That worked splendidly.