How to undo static time formatting?

%3CLINGO-SUB%20id%3D%22lingo-sub-2712973%22%20slang%3D%22en-US%22%3EHow%20to%20undo%20static%20time%20formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2712973%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hit%20shortcut%20keys%20for%20applying%20static%20time%20with%20only%20one%20cell%20selected.%26nbsp%3B%20I%20expected%20it%20would%20be%20applied%20to%20this%20cell%20only%2C%20but%20instead%20it%20got%20applied%20to%20all%20of%20my%20cells%20containing%20time%20values.%26nbsp%3B%20I%20tried%20clearing%20all%20formating%20from%20these%20cells%2C%20changing%20time%20format%2C%20but%20nothing%20works.%26nbsp%3B%20%26nbsp%3BOn%20top%20of%20that%20it%20made%20my%20subtraction%20formulas%20which%20were%20tied%20to%20those%20data%20dysfunctional%20%3B%20meaning%20I%20can%20see%20these%20formulas%20displayed%20in%20cells%2C%20but%20hitting%20enter%20won't%20return%20the%20result.%26nbsp%3B%20Also%2C%20all%20the%20formated%20cells%20display%20time%20in%20decimals.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20fix%20for%20this%20or%20is%20static%20time%20supposed%20to%20be%20irreversible%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2712973%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2713172%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20undo%20static%20time%20formatting%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2713172%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1144878%22%20target%3D%22_blank%22%3E%40SplitsOfEcstasy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20share%20sample%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I hit shortcut keys for applying static time with only one cell selected.  I expected it would be applied to this cell only, but instead it got applied to all of my cells containing time values.  I tried clearing all formating from these cells, changing time format, but nothing works.   On top of that it made my subtraction formulas which were tied to those data dysfunctional ; meaning I can see these formulas displayed in cells, but hitting enter won't return the result.  Also, all the formated cells display time in decimals. 

 

Is there any fix for this or is static time supposed to be irreversible? 

 

 

1 Reply

@SplitsOfEcstasy 

Could you please share sample file?