+ Reply to Thread
Results 1 to 2 of 2

Counting Attendance along with Productivity

  1. #1
    Registered User
    Join Date
    03-10-2016
    Location
    Warsaw
    MS-Off Ver
    2010
    Posts
    1

    Counting Attendance along with Productivity

    hello all ,
    I am doing some scheduling excel file , and I have in department different shifts , so in the schedule file I have already the formula that calculates how many people work in morning and how many in evening , but there is something missing A productivity is 60% , B productivity is 50% , C Productivity is 100%, A and B works morning, C is evening

    100% SL SL L M
    50% M M M M
    60% E L E L

    Productivity 1.1 0.5 1.1 1.5 how can I get these productivity number using formulas?
    so the formula should count how man M , and multiple by the productivity indicator for the person.

    Regards,
    Trainder008

  2. #2
    Forum Contributor
    Join Date
    08-30-2007
    Location
    Vancouver, B.C.
    Posts
    149

    Re: Counting Attendance along with Productivity

    Can't really picture what you are asking. Perhaps post the worksheet?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  2. Lab Productivity
    By omer123456 in forum Excel General
    Replies: 13
    Last Post: 12-23-2015, 04:06 PM
  3. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  4. Replies: 7
    Last Post: 02-11-2015, 11:23 AM
  5. Counting work occurrences for attendance
    By daneff in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-05-2014, 07:01 AM
  6. Productivity
    By mmitri in forum Excel General
    Replies: 3
    Last Post: 09-24-2012, 07:50 PM
  7. Replies: 3
    Last Post: 06-12-2011, 02:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1