Улучшение ответа HABO:
select top 10 Cast(DateAdd( ms,avg(DateDiff( ms, '00:00:00', e.Duration)), '00:00:00' ) as time) as 'avg duration' from TimeTable e