Home

Formula needed for meeting KPI precentage

Submitted by harpnjsn on 26 October, 2015 - 03:38
Formula needed for meeting KPI precentage

Can anyone please give me the formula for a percentage at the bottom of column E. The data in Column E is hours and minutes eg. Row 3 Column E is 20 hours and 55 minutes. I need the percentage of how many jobs (each row is a job) are being performed in less than 24 hours. Thanks.

»

Here you go - this should do it

Submitted by markthemacroman on 4 January, 2016 - 17:15.

=COUNTIF(E2:E10,"<24.01")/COUNT(E2:E10)*100

Stick this in cell E11

»