SELECT ROUND( AVG(TIMESTAMPDIFF(MINUTE,a.create_time,b.out_time)/60) ,3) AS time FROM express_tb AS a INNER JOIN exp_action_tb AS b ON (a.exp_number = b.exp_number)