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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up a formula to give me an average based on IF? 1
Insert Column, Keep Average range 1
Average of time spent monthly getting DIV/0 error 2
Sumproduct in matrix means 3
add/sub time/hour tracking in 24 clock format 1
help with 12 week rolling average 3
Average IF? 1
aauugghhh...#div/o problems & various average formula problems 5

Top