I have an employee spreadsheet with various data on it. I need to pull data from two adjacent columns and total just one of them.
One column(I) has each employees employment status: PT or FT
The second column(H) that is adjacent has each employees hours worked in a week.
I would like to total up the hours for all employees by their employment status and then divide each total by 4.
Total PT Hours per Week/ Month 0
Total FT Hours per Week/Month 0
Hopefully my explanation was clear... This is a project to determine my businesses exposure to the new Health Care Plan requirements. Once I get the "PT & FT" totals I will apply them to the governments formula.
Thanks in advance for any help.
John
Bookmarks