View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
m greenly m greenly is offline
external usenet poster
 
Posts: 1
Default average of times

i have times listed as "h:mm" and i would like to show the average. note that
the times are calculated, not entered manually.
formula in time row: =TEXT(C2-B2, "h:mm")

what formula would i put in the cell where i want the average of all times?
thanks for your help.