Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Excell 2003
I'm trying to average times, in minutes, in a single column. The minutes are the result of a formula to find elapsed times (14:10-14:08 etc). There are 1414 cells in the column with entries in about 80% of the cells. In one of the books I have it says Excell will only average 20 numbers. If this is true, how do I average the column? On a relaterd topic, wehn I try to do MAX for the columns I get a number that I know isn't the MAX for that column. I've got the columns formated for times. What am I doin wrong? Thanks, The 'Bonker -- Its better to remain silent and be thought a fool than open ones mouth and remove all doubt. Creditied to Mark Twain. So I guess I''ve removed all doubt. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average Formula | Excel Discussion (Misc queries) | |||
rolling average | Excel Worksheet Functions | |||
Modified Average Function | Excel Worksheet Functions | |||
plotted Average | Charts and Charting in Excel | |||
What is this kind of average called? | Excel Worksheet Functions |