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

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