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.
|