Home

current hour

%3CLINGO-SUB%20id%3D%22lingo-sub-407851%22%20slang%3D%22en-US%22%3Ecurrent%20hour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407851%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20put%20the%20format%20of%20the%20cell%20on%20hour%20and%20after%20i%20press%20ctrl%2B%3B%20to%20have%20back%20the%20current%20hour%20but%20it%20doesn't%20work%2C%20why%3F%3C%2FP%3E%3CP%3Ethank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-407851%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-408104%22%20slang%3D%22en-US%22%3ERe%3A%20current%20hour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-408104%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316053%22%20target%3D%22_blank%22%3E%40emipierangeli%3C%2FA%3E%26nbsp%3B%2C%20it%20depends%20on%20your%20locale%2C%20other%20words%20language%20version%20of%20Excel%20and%20keyboard%20layout.%20In%20my%20case%20current%20time%20is%20returned%20by%20Ctrl%2BShift%2B%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
emipierangeli
Occasional Visitor

I've put the format of the cell on hour and after i press ctrl+; to have back the current hour but it doesn't work, why?

thank you

1 Reply

@emipierangeli , it depends on your locale, other words language version of Excel and keyboard layout. In my case current time is returned by Ctrl+Shift+;

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies