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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 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
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies