I am trying to average 'call handle time' for a week.

1) I use VLOOKUP to pull the data from a daily report
2) I have applied a format of [h]:mm:ss

The cells look like this -- it's throwing a #DIV/0! error. Any ideas?
D6 E6 F6 G6 H6
00:05:10 00:04:17 00:04:50 00:05:21 00:05:10 #DIV/0!