[TABLE="width: 128"]

<colgroup><col span="2"></colgroup><tbody>[TR]

[TD]9:03[/TD]

[TD]9:03[/TD]

[/TR]

[TR]

[TD]8:51[/TD]

[TD]8:51[/TD]

[/TR]

[TR]

[TD]9:15[/TD]

[TD]9:15[/TD]

[/TR]

[TR]

[TD]8:12[/TD]

[TD]8:12[/TD]

[/TR]

[TR]

[TD]4:47[/TD]

[TD]4:47[/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]7:28[/TD]

[TD]7:28[/TD]

[/TR]

[TR]

[TD]9:06[/TD]

[TD]9:06[/TD]

[/TR]

[TR]

[TD]8:53[/TD]

[TD]8:53[/TD]

[/TR]

[TR]

[TD]9:06[/TD]

[TD]9:06[/TD]

[/TR]

[TR]

[TD]9:23[/TD]

[TD]9:23[/TD]

[/TR]

[TR]

[TD]7:51[/TD]

[TD]7:51[/TD]

[/TR]

[TR]

[TD]9:02[/TD]

[TD]9:02[/TD]

[/TR]

[TR]

[TD]8:46[/TD]

[TD]8:46[/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]8:30[/TD]

[TD]8:30[/TD]

[/TR]

[TR]

[TD]9:48[/TD]

[TD]9:48[/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]10:04[/TD]

[TD]10:04[/TD]

[/TR]

[TR]

[TD]9:03[/TD]

[TD]9:03[/TD]

[/TR]

[TR]

[TD]7:49[/TD]

[TD]7:49[/TD]

[/TR]

[TR]

[TD]8:01[/TD]

[TD]8:01[/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD]18:58[/TD]

[TD]00:00[/TD]

[/TR]

[TR]

[TD]08:34[/TD]

[TD][TABLE="width: 64"]

<tbody>[TR]

[TD]#DIV/0![/TD]

[/TR]

</tbody>[/TABLE]

[/TD]

[/TR]

</tbody>[/TABLE]

The first column was correctly added where the TOTAL = 18:58 and AVERAGE = 08:34 However, with this first column, I used the long formula = a1+a2+a3+a4+a5+a6... and then to take the average =a36/19 BUT THIS IS THE LONG WAY... which isn't practical in the office.

Looking at the 2nd column, I tried the shortcut =sum(a1:a35) The result was 00:00 What am I doing wrong?

I even custom formatted it to hh:mm

I tried using =average(a1:a35) Nothing's coming out or I get a #DIV/0! What am I doing wrong?