View Single Post
  #31   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default 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.