Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-26-2016, 02:48 AM
xor xor is offline Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time Windows 10 Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Not sure if I have understood you correct, but you might want to take at look at the attached. In particular I don't know how you distinguish between Department 1, Department 2 and Department 3.

I have combined your two files into one and put some formulas in sheet Full Time Turnover by Month (and also a Pivot table).

Please note that status, FT.PT and status.Date are defined names (See Name Manager).

You can change the year in cell A3.
Attached Files
File Type: xlsx Turnover Calculation_2.xlsx (137.0 KB, 71 views)
Last edited by xor; 03-26-2016 at 06:40 AM.
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time Graph occurences over full range of time? pixeldroid Excel 1 07-13-2015 09:30 AM
Next to the resource bar Part-time% BuffLouis Project 3 08-18-2014 06:05 AM
Count the common time period (month) between two date period of time Barni Excel 6 08-15-2014 07:52 AM
Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time Employee time tracking using email iampav Outlook 1 06-07-2012 06:54 AM
Employee Turnover by Department/Month split between Voluntary/Involuntary - Full-time/Part-time Part Time Resource Query iamthequinn Project 1 02-06-2012 08:15 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:08 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft