Jan 23 2019 06:15 PM
Hi all,
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.
Thank you very much for any suggestions.
Rick Lizotte
Jan 24 2019 12:59 PM
SolutionHi Rick,
You can't change such behaviour. As workaround you may use [h]:mm format but interpret values entered as minutes and seconds displayed. However, in calculations to use like =A1/60 where necessary.
Jan 24 2019 05:59 PM
Thanks Sergei,
That's what I thought, but one can always hope.
Rick
Jan 24 2019 12:59 PM
SolutionHi Rick,
You can't change such behaviour. As workaround you may use [h]:mm format but interpret values entered as minutes and seconds displayed. However, in calculations to use like =A1/60 where necessary.