Results 1 to 5 of 5

working out productivity using HOURS and units to establish accurate daily result

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    United Kingdom
    MS-Off Ver
    Office 2007
    Posts
    89

    working out productivity using HOURS and units to establish accurate daily result

    Hi,

    I have a slight issue with a formula. Seems to work most of the time but have an issue with smaller numbers.

    The formula I am using to calculate productivity is:

    =B26/HOUR(G26/(7*F26))

    One person is coming up with a #DIV/0 error and this appears to be because when evaluating the formula we have a 0.267777 and then B26 tries to divide by zero hence the error.

    The numbers I have are as follows:

    B26 = 7
    G26 = 5:46 (in [h]:mm format)
    F26 = 1

    basically the formula is = (new cases/(hours worked*FTE)

    any help around the error or a better formula?
    Last edited by Raanan; 10-21-2013 at 11:32 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Productivity
    By mmitri in forum Excel General
    Replies: 3
    Last Post: 09-24-2012, 07:50 PM
  2. Weekly productivity, hours working vs multiple proccesses
    By rowanmann in forum Excel General
    Replies: 1
    Last Post: 05-13-2012, 09:00 AM
  3. Productivity Formula
    By Warehouse Dan in forum Excel General
    Replies: 5
    Last Post: 04-03-2012, 10:01 PM
  4. productivity calculation
    By Tanglefoot in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-24-2006, 11:54 PM
  5. [SOLVED] employee productivity
    By RompStar in forum Excel General
    Replies: 4
    Last Post: 04-28-2005, 03:06 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