Understanding Log Partial Count If...

Log Partial Count if... is used to convert and record a set of hours worked into counts.

Log partial count if...is used by organizations that balance opportunity counts and hours worked to equitably distribute working opportunities.

For example, if a work opportunity runs for 6 hours only 0.25 hours are logged for each occurrence. So 12 hours logs at 0.5, 18 hours logs at 0.75, and 24 hours logs at 1.0. If Employee 1 accepts a 12 hour shift, he moves down the list with 0.5 hours logged. Next in line, Employee 2 accepts a 6 hour shift. Employee 2 moves down the list and ahead of Employee 1 because Employee 2 logged less hours than Employee 1.

The example above is entered as follows:

Log partial count if < 6.01,0.25;12.01,0.50;18.01,0.75;24,1.0

Note:

Separating each partial count with a semicolon creates partials.

The table below illustrates the example above.

Name Opportunity
Employee 3 --
Employee 2 0.25
Employee 1 0.50

Rules control ascending or descending sort order.