Forum Discussion

sfernamer's avatar
sfernamer
Icon for Helper III rankHelper III
3 years ago

Average time grouped by column

Hi everyone!   I'm working with time (minutes and seconds played) and would like to get the average time for every distinct pair of players. I tried the following formula but didn't work because it...
Need Help
sfernamer's avatar
sfernamer
Icon for Helper III rankHelper III
3 years ago

Hi Ahmedx 

Your answer worked for almost all cases but there are cases where the result is "00:00:60" instead of "00:01:00", Idk why is not rounding this number but, if I wanna convert the text result into time, it's not working for these cases. For the other ones, it's working perfectly. 

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
3 years ago

you can create an example where the measure counts incorrectly?