LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 39
Default average hourly output for date, result shown by day

thanks Max


"Max" wrote:

.. plug into the table below, for each day and would return the results

mm, but that's exactly what was suggested?
How about a little working sample to illustrate it:
http://cjoint.com/?lfqpzRHQm2
Average n Sum by day.xls
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Morgan" wrote:
sorry Max, i couldn't get it to work, the first formula seems to leave out
column M 'output' i just wanted a formula that i could plug into the table
below, for each day and would return the results, thanks for trying though

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


--
thanks


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
different values shown when #DIV/0! error is returned as result Danko Jotanovic Excel Discussion (Misc queries) 3 September 4th 09 09:18 AM
hourly average help bob New Users to Excel 10 July 5th 09 12:05 AM
why result 77.1 * 850 shown 100000 in excel 2007? nth Excel Discussion (Misc queries) 4 February 9th 08 07:14 PM
Using a time value in an Excel formula to figure an hourly average Chuck Walsh Excel Discussion (Misc queries) 1 October 23rd 07 09:07 PM
how do I output result of formula to another cell? Francois Excel Discussion (Misc queries) 3 November 24th 06 03:02 PM


All times are GMT +1. The time now is 11:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"