Calculate Average of time HH:MM MySql Php

Hello,

I have a table with time field that stores 24hr. time duration in HH:MM format, 
need help to calculate Average of time values across the table.

Example:
03:15
05:13
10:20

Any help would be appreciated.

@ebaad,

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

@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.

@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`