Avg Formula on a Duration Column
I have read the forum and still having issues with this formula. I am simply trying to average the duration column. It returns a Divided by Zero error and have tried adding this into my formula. What is a sheet summary formula that would average the duration column. Any help is greatly appreciated :)
Answers

Hi Denise .
Hope you are well!
By Duration do you only need Hours:Minutes ?
You will have to have a Sum Formula 1st and then Use a INT Formula to calculate it back
Here is an example of my sheet and formulas that I used.
SUM:
=(VALUE(LEFT([TIME OUT:]@row; FIND(":"; [TIME OUT:]@row)  1)) + (VALUE(RIGHT([TIME OUT:]@row; 2)) / 60) + ([DATE OUT:]@row  [DATE IN:]@row) * 24)  (VALUE(LEFT([TIME IN:]@row; FIND(":"; [TIME IN:]@row)  1)) + (VALUE(RIGHT([TIME IN:]@row; 2)) / 60))
DURATION:
=INT([SUM:]@row) + ":" + IF(([SUM:]@row  INT([SUM:]@row)) * 60 < 10; "0") + ([SUM:]@row  INT([SUM:]@row)) * 60
Kind Regards
Brandon
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!