How do you calculate average time?
 

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?

"G Man" wrote:

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.

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?

"Barb R." wrote:

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

"G Man" wrote:

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.

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.
"G Man" wrote:

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?

"Barb R." wrote:

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

"G Man" wrote:

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.

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



G Man wrote:

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.

--

Dave Peterson