Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula calculating fulltime/parttime vs employees.
I have a spreadsheet listing employees jobs in one column. Another column
lists if they are full time or part time. There are several employees with the same job but work different times. I need a formula to calculate how many people with that title work full time and how many people with the same job work part time. |
#2
|
|||
|
|||
A pivot table will do a very nice job for you. They are very powerful once you
get to know them. Take a look at Chip Pearson's site for a tutorial on them: http://www.cpearson.com/excel/pivots.htm -- Regards, Fred "VP" wrote in message ... I have a spreadsheet listing employees jobs in one column. Another column lists if they are full time or part time. There are several employees with the same job but work different times. I need a formula to calculate how many people with that title work full time and how many people with the same job work part time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for calculating price | Excel Discussion (Misc queries) | |||
formula used for FTE employees | Excel Discussion (Misc queries) | |||
formula for calculating # of days between 2 cells | Excel Worksheet Functions | |||
formula for calculating 401k if over or equal to 1 yr of service . | Excel Worksheet Functions | |||
Calculating tax Formula | Excel Discussion (Misc queries) |