Calculate Average of time HH:MM MySql Php

@ebaad,

When you save average time...do you mean by the hour or hour and minutes?

Thanks, I am looking to get average time in HH:MM format to show the Min, Max and Average time to respond on events.

Hello, I hope this helps you:

SELECT SEC_TO_TIME(AVG(TIME_TO_SEC(`hours`))) FROM `table_name`