Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Averaging Times

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a spreadsheet where employees daily hours are tracked. I would like to be able to get an average hours worked for all employees. What is the best way to do this, the formulas I have tried don't seem to calculate it properly?

    [ This Message was edited by: jvidosh on 2002-04-13 13:48 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-13 13:48, jvidosh wrote:
    I have a spreadsheet where employees daily hours are tracked. I would like to be able to get an average hours worked for all employees. What is the best way to do this, the formulas I have tried don't seem to calculate it properly?

    [ This Message was edited by: jvidosh on 2002-04-13 13:48 ]
    =AVERAGE(F2:25)

    where F2:F5 houses properly formatted time values.

    The cell of this formula should be custom formatted as

    [h]:mm

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-13 15:32, jvidosh wrote:
    Thanks for your help. I had tried that but it doesn't look right to me, when I do it manually I get a different number. I figured out why number wasn't correct, as I was preparing to illustrate the problem to you, I discovered my error. I also need to be able to not only include cells that have an error (due to the fact I have the start time already input and the employee did not work that day) but cells with no value at all (I have blank fields to add new employees). So I will need a count or/and if : then statement, correct? That is why my averages didn't look correct, I was averaging in blank and errored out cells. Any additional help would be appreciated, I'm going work on it here to. Thanks

    John


    [ This Message was edited by: jvidosh on 2002-04-13 15:56 ]

    [ This Message was edited by: jvidosh on 2002-04-20 06:34 ]

    [ This Message was edited by: jvidosh on 2002-04-20 06:35 ]

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,645
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-13 15:55, jvidosh wrote:
    On 2002-04-13 15:32, jvidosh wrote:
    Thanks for your help. I had tried that but it doesn't look right to me, when I do it manually I get a different number. I figured out why number wasn't correct, as I was preparing to illustrate the problem to you, I discovered my error. I also need to be able to not only include cells that have an error (due to the fact I have the start time already input and the employee did not work that day) but cells withno no value at all (I have blank fields to add new employees). So I will need a count or/and if : then statement, correct? That is why my averages didn't look correct, I was averaging in blank cells. Any additional help would be appreciated, I'm going work on it here to. Thanks

    John


    [ This Message was edited by: jvidosh on 2002-04-13 15:56 ]
    John,

    AVERAGE ignores blank cells. What kind of error values do you have in the range of time values that we want to average? Would you also post the formula that computes the values to be averaged?

    Aladin

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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