Thread: Averaging
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hookette Hookette is offline
external usenet poster
 
Posts: 5
Default Averaging

If I have a column of data that I got using this formula:

DATEDIF(B2,C2,"m") & " months " & DATEDIF(B2,C2,"md") & " days " &
TEXT(C2-B2,"hh") & " hours " & LEFT(TEXT(C2-B2,"mm:ss"),2) & " minutes"

is there any way to then get an average from that column. When I used the
regular average function that didn't work.

Thanks.