How do you calculate average time?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to track the average time a person uses a piece of equipment at
work. The average function does not seem to recognize time less than 1 hour
(i.e :37) in duration. I have about 30 occasions when the equipment was
used-- ranging from :05 to 3:10.

I appreciate your help.
 
I just tried it and am not having an issue. Are you sure that all of the
cells are formatted the same way?
 
Yes. How are you getting the average? If I try to average :40, :39, :25, I
get an error (#DIV/0!). What's the correct format or formula?
 
Try formatting the cells including the one used for the average using
Format -> Cells -> Time -> 13:30
Come back and let me know what you get.
 
If you're typing :37, excel will be seeing your entry as text.

Try typing 0:37.

To fix a bunch at once:
Select that range of cells.
edit|Replace
what: : (just the colon)
with: 0: (added zero)
replace all
 
You must log in or register to reply here.

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

military time calculations 1
Average of a string containing multiple values 20
Average Time for Specific Item 9
Calculating average ages 5
Average problem 1
Calculating Average 2
Calculate number needed to maintain an average 2
Sum and average number of days and hours 4

Back
Top