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

Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM 2
Calculating an average of data between two dates 1
Using the IF and IFBLANK functions 3
Need Help with a VBA subroutine 0
Finding the weighted average of text that have been given values 1
Excel 2003 Function Help 4
Sumproduct in matrix means 3
How do I highlight past dates 3

Top