MS-EXCEL: time averages + numbers to time
<p>I am working on a project for my work and I am having an issue trying to take times and averaging them out. I am getting a <code>#DIV/0!</code> When I convert the cells to <code>XX:XX</code>. </p>

<p>Below are screen shots of the same data and function. The top is with regular numbers the bottom is where I formatted all cells to display in time XX:XX.</p>

<p>Numbers (works fine) </p>

<pre><code>  = AVERAGE(H29,J29,P29,V29,AE29,AJ29)
</code></pre>

<p><img src="https://i.imgur.com/n8gic6x.png" alt="numbers"></p>

<p>Time <code>(XX:XX)</code> however I get the <code>#DIV/0!</code>. The <code>AVERAGE</code> Function I am using looks like this:</p>

<pre><code> =AVERAGE(H29,J29,P29,V29,AE29,AJ29)
</code></pre>

<p><img src="https://i.imgur.com/aN5qxL9.png" alt="time"></p>

<p>Also, if possible, could I enter the data in regular numbers (not time) then have it display in average time (<code>hours:min</code>) on the right?. </p>

<p>Thank you. </p>