Reputation
320
Top tag
Next privilege 500 Rep.
Access review queues
Badges
4 10 20
Impact
~171k people reached

Feb
1
comment Show dynamic time (and not date) in excel
Hi Admingrl, and welcome to SuperUser. Your answer is great if I want a shortcut for displaying the time one-time-only. But I was looking for a way to display the current time dynamically - that each time I open the spreadsheet, the cell will show the current time.
Nov
19
awarded  Famous Question
Jul
23
awarded  Nice Question
Jul
2
awarded  Curious
Apr
30
awarded  Favorite Question
Nov
27
awarded  Notable Question
May
9
awarded  Popular Question
Mar
28
awarded  Notable Question
Feb
20
awarded  Famous Question
Jan
31
awarded  Nice Question
Sep
10
awarded  Announcer
Jul
22
awarded  Caucus
Jul
3
awarded  Notable Question
Jun
8
awarded  Caucus
Apr
1
accepted Show dynamic time (and not date) in excel
Mar
25
comment Show dynamic time (and not date) in excel
Thanks, @SivaCharan!
Mar
25
comment Show dynamic time (and not date) in excel
@barryhoudini - it's fine. It still acts as a time - I'm able to subtract another time cell from it
Mar
25
comment Show dynamic time (and not date) in excel
Thanks, but this is what I do now. What I'm looking for is a way that will save me these 5 steps...
Mar
25
awarded  Commentator
Mar
25
comment Show dynamic time (and not date) in excel
This gives me some kind of digital number, unless I format the cell as date... But I don't want to have to format the cell explicitly. With the now() function, the cell formats without any external intervention...