SOLVED
Home

Entering Time Data

%3CLINGO-SUB%20id%3D%22lingo-sub-324727%22%20slang%3D%22en-US%22%3EEntering%20Time%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324727%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%E2%80%99m%20having%20trouble%20working%20with%20elapsed%20time%20in%20minutes%2Fseconds.%20The%20values%20are%20from%20rapid%20chess%20games%20of%2030%20minutes%20for%20each%20player%20and%20I%20would%20like%20to%20calculate%20the%20average%20time%20remaining%20for%20each%20player.%20It%20seems%20to%20work%20if%20I%20format%20the%20cells%20%5Bh%5D%3Amm%3Ass%20and%20enter%20a%20zero%20for%20the%20hours.%20Is%20there%20a%20way%20to%20do%20it%20without%20having%20to%20enter%20the%20zero%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20need%20help%20with%20charts%2C%20but%20that%E2%80%99s%20for%20another%20post.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20any%20suggestions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERick%20Lizotte%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-324727%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-325368%22%20slang%3D%22en-US%22%3ERe%3A%20Entering%20Time%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325368%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Sergei%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20what%20I%20thought%2C%20but%20one%20can%20always%20hope.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERick%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-325245%22%20slang%3D%22en-US%22%3ERe%3A%20Entering%20Time%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-325245%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Rick%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can't%20change%20such%20behaviour.%20As%20workaround%20you%20may%20use%20%5Bh%5D%3Amm%20format%20but%20interpret%20values%20entered%20as%20minutes%20and%20seconds%20displayed.%20However%2C%20in%20calculations%20to%20use%20like%20%3DA1%2F60%20where%20necessary.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Rick.Lizotte
Occasional Contributor

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

Thanks Sergei,

 

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

 

Rick

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies