average hourly output for date, result shown by day - microsoft.public.excel.newusers

Message from discussion average hourly output for date, result shown by day

Eduardo

View profile

More options Nov 4 2009, 9:00 pm

Newsgroups: microsoft.public.excel.newusers

From: Eduardo <Edua...@discussions.microsoft.com>

Date: Wed, 4 Nov 2009 05:00:01 -0800

Local: Wed, Nov 4 2009 9:00 pm

Subject: RE: average hourly output for date, result shown by day

  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Hi,
use

=if(A2="","",TEXT(A2,"dddd"))

to get the average just do

=M2/D2

"Morgan" wrote:
> hello there,

> i have a template in excel2007 that is blank until the data will begin to be
> entered, in column A i have the date in the format 14/03/01, in column D i
> have hours worked (in regular number eg 2.89) and in column M i have output
> in units.

> i was wondering if there was a formula that could return the average hourly
> output and total output in the style below?

> Average Hourly Output Total Output
> Monday
> Tuesday
> Wednesday
> Thursday
> Friday
> Saturday
> Sunday

> i have tried setting up another column that corresponds to the date column
> A, and trying to get the above the long way using the formula
> =TEXT(A2,"dddd") but as it is based on empty cells, all the blank cells come
> up with 'saturday' or the last value,

> any help would be great thank you!

> --
> cheers

Forward