Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on averaging function
"Meebers" wrote...
The goal is to see the patients on time. If we are late, it is a negative amount, early it is a positive. Yes the differences are in times, results are formated as a number since negative #'s will not format as hh:mm. .... TIf you saw 60 patients, 50 on time, 8 5 minutes early and 2 30 minutes late, would you want the average to be 20 seconds late or 2 miutes late? The first includes the 50 on time (0) values, the latter doesn't. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Looking for conditional averaging or "Averageifs" function for | Excel Worksheet Functions | |||
Looking for conditional averaging or "Averageifs" function for | Excel Worksheet Functions | |||
Looking for conditional averaging or "Averageifs" function for '02 | Excel Worksheet Functions | |||
Averaging function is pulling back a zero in Excel | Excel Discussion (Misc queries) | |||
Averaging function | Excel Discussion (Misc queries) |