Hi!

Im trying to calculate the average time elasped in 2 columns in Days, Hours and Minutes format. I have used this formula to to get the time elapsed


=INT(J33-D33)&" days "&TEXT(J33-D33,"h"" hrs ""m"" mins """)

However, when I try to get the average in the column in cell L46 I get either #DIV/0 or #Value! error message.

Here's the spreadsheet I'm working on


Average Time in Days & Hours.xlsx - Google Drive


Any help would be most appreciated

Thanks