Entering Time Data

[Rick.Lizotte]

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

[#2 · Accepted solution]

Hi 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.

[#3]

Thanks Sergei,

That's what I thought, but one can always hope.

Rick