Results 1 to 15 of 15

Need formula for productivity calculation

Threaded View

  1. #10
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Need formula for productivity calculation

    Hi

    With your data I can not understand what you really want. Where are the data to 'Start time' and 'Finish time'?

    Analyze the results that I calculated and use your data to write, in Sheet3, what you really wanted to find.

    In E5: E11 I determined counts with
    Formula: copy to clipboard
    =COUNTIFS($A$17:$A$25,$A5,$B$17:$B$25,E$4)

    To calculate the time spent use in J5 the following formula
    Formula: copy to clipboard
    =INDEX(MMULT(E5:H5,'Time Frame'!$B$2:$B$5),0)

    See the file
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Productivity Calculation
    By Rushendra in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-07-2017, 10:32 AM
  2. employees production and productivity calculation
    By Giri.hb in forum Excel General
    Replies: 4
    Last Post: 06-29-2014, 10:04 AM
  3. Productivity calculation
    By genichigo in forum Excel General
    Replies: 2
    Last Post: 05-23-2012, 04:48 PM
  4. Shift Productivity Calculation
    By Kheldar in forum Excel General
    Replies: 1
    Last Post: 02-03-2011, 02:10 PM
  5. productivity formula
    By sccottt in forum Excel General
    Replies: 7
    Last Post: 10-01-2010, 06:58 AM
  6. Calculation of Productivity
    By roshan.sayed in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2008, 10:18 AM
  7. productivity calculation
    By Tanglefoot in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2006, 11:54 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