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

  • Thread starter Thread starter Thomas
  • Start date Start date
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
 
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 40hr work week 8
add/sub time/hour tracking in 24 clock format 1
help with 12 week rolling average 3
How do I set up a formula to give me an average based on IF? 1
Averaging set of data based on the time 2
Averaging a column that contains text 4
Average of time spent monthly getting DIV/0 error 2

Back
Top