I’m having trouble working with elapsed time in minutes/seconds. The values are from rapid chess games of 30 minutes for each player and I would like to calculate the average time remaining for each player. It seems to work if I format the cells [h]:mm:ss and enter a zero for the hours. Is there a way to do it without having to enter the zero?
I also need help with charts, but that’s for another post.