how do I average a column in HR:MIN format (4:12)

T

Thomas

I am tracking a contractors hours in house. How do I average a column that
is represented in HR:MIN format?
4:12
3:52
4:26
I want my answer in the same format.

Thank you
 
R

Roger Govier

Hi Thomas

=AVERAGE(A1:A3)
Format the cell with the formula as Format>Cells>Number>Custom>hh:mm
 
Top