ExcelBanter - Counting .5 in a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting .5 in a pivot table (https://www.excelbanter.com/excel-worksheet-functions/44471-counting-5-pivot-table.html)

mtcurtis

Counting .5 in a pivot table

I have a pivot table of employees. Some of the employees work part-time and
are counted as .5 headcount. Can I get the pivot table to count .5 for those
employees?

Bernie Deitrick

You need another column in your data source, with .5 for part-time and 1 for full-time.

HTH,
Bernie
MS Excel MVP

"mtcurtis" wrote in message
...
I have a pivot table of employees. Some of the employees work part-time and
are counted as .5 headcount. Can I get the pivot table to count .5 for those
employees?

All times are GMT +1. The time now is 07:30 PM.