Calculate percentage for specific IF criteria

Copper Contributor

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


With helper column and pivot table.


best response confirmed by Mollie523 (Copper Contributor)

@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:


In Z2:


In Z3:


@Hans Vogelaar Thank you! That worked splendidly.