calculate average time

**sarinky** · 02-29-2012, 04:23 AM

Hi everyone,

Can =average formula calculate time average. It seems not work with me. I have a list with time format and I want to find the average.

regards,
Sarin

**Pepe Le Mokko** · 02-29-2012, 04:24 AM

The AVERAGE function should work. What goes wrong? Did you format the result correctly ?

**sarinky** · 02-29-2012, 04:38 AM

My format is hh:mm. but my calculation using average is different from what appeared on status bar. but when I format hh:mm:ss, it went correctly. What's the cause?

Regards,
Sarin