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