Average time not calculating

[Helloitsme]

Hi everyone,

Trying to get the average processing time of coloumn K but I get a #DIV/0! error. Does anyone know what could be wrong? Both coloumns are formatted as TIME values but K is still text when using =ISTEXT. Formula =AVERAGE(K2:K10)

I get a #VALUE! error when using this formula =AVERAGE(VALUE(TEXT("00"&K2:K10;"tt:mm:ss")))

I hope someone will be able to help

 

[FormR]

Hi, it would probably be best to convert your times to actual time values, but you could try dropping TEXT() function from your attempted formula as that is converting it back to text.

Also, I don't see what the "00" concatenation adds - so you could try:

=AVERAGE(VALUE(K2:K10))