Hi, I've been using the below formula to give me total days, hours and minutes between two dates, this will deliver a result similar to <1 Days 1 hrs 23 mins>
=IFERROR(INT(E195-D195)&" Days "&TEXT(E195-D195," H "" hrs ""m"" mins """),0)
I then use the below formula to calculate total, however what I'd really like next is the average days hours and minutes across the range, any suggestions about changing the formula to accommodate?
=INT(SUMPRODUCT(H2:H195-G2:G195))&" days "&TEXT(SUMPRODUCT(H2:H195-G2:G195),"h"" hrs ""m"" mins """)
=IFERROR(INT(E195-D195)&" Days "&TEXT(E195-D195," H "" hrs ""m"" mins """),0)
I then use the below formula to calculate total, however what I'd really like next is the average days hours and minutes across the range, any suggestions about changing the formula to accommodate?
=INT(SUMPRODUCT(H2:H195-G2:G195))&" days "&TEXT(SUMPRODUCT(H2:H195-G2:G195),"h"" hrs ""m"" mins """)