Forum Discussion

Rick.Lizotte's avatar
Rick.Lizotte
Copper Contributor
Jan 23, 2019
Solved

Entering Time Data

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

excel
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 24, 2019

    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.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 24, 2019

    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.

    • Rick.Lizotte's avatar
      Rick.Lizotte
      Copper Contributor
      Jan 24, 2019

      Thanks Sergei,

       

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

       

      Rick