How do you calculate average time?

G

G Man

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.
 
B

Barb R.

I just tried it and am not having an issue. Are you sure that all of the
cells are formatted the same way?
 
G

G Man

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?
 
B

Barb R.

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.
 
D

Dave Peterson

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
 
Top