"Luke M" wrote:
Also, of note, this:
LEFT(TEXT(C2-B2,"mm:ss"),2)

can be simplified to simply:
TEXT(C2-B2,"mm")

I don't think so.

Test with C2-B2 equal to 32.5. LEFT(TEXT(32.5,"mm:ss"),2) results in "00",
whereas TEXT(32.5,"mm") results in "02".

To understand why, format 32.5 with the custom format "m/d/yyyy h:mm"
without quotes; note that it appears as 2/1/1900 12:00. TEXT(...,"mm")
returns the month number in digits, not the minutes.


----- original message -----

"Luke M" wrote in message
...
Not directly, because the output of this formula is text, and you've got
the
values mixed in with text. If you're wanting to do averages, I would
recommend splitting this formula up into multiple columns.

Also, of note, this:
LEFT(TEXT(C2-B2,"mm:ss"),2)

can be simplified to simply:
TEXT(C2-B2,"mm")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hookette" wrote:

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.