Averaging Times

jvidosh · Apr 13th, 2002, 02:48 PM

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 ]

Aladin Akyurek · Apr 13th, 2002, 02:50 PM

Quote:

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

jvidosh · Apr 13th, 2002, 04:55 PM

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 ]

Aladin Akyurek · Apr 13th, 2002, 04:59 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 13th, 2002, 02:48 PM	#1
jvidosh New Member Join Date: Apr 2002 Posts: 2	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 ]

Apr 13th, 2002, 04:55 PM	#3
jvidosh New Member Join Date: Apr 2002 Posts: 2	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 ]