E
engine99
How do you continuously update time and date in an Excel cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Ragdyer
=NOW()
E
engine99
The fuction as written does not appear to continuously update with the
computer clock. However it does update when you save any change to the file.
I need the date and time to update continuously or at least every 5
minutes...
Ray Fry
computer clock. However it does update when you save any change to the file.
I need the date and time to update continuously or at least every 5
minutes...
Ray Fry
R
Ragdyer
You'll need code for that.
M
Myrna Larson
What is the purpose of this? If it's just to see the time of day, and the
value isn't used in calculations, the clock is usually displayed on the task
bar.
value isn't used in calculations, the clock is usually displayed on the task
bar.
P
Peo Sjoblom
E
engine99
The time will be used to determine what set of cells I pull data from; from
4:30 pm to 7:00 am I will pull data from cells A and from 7:00 am till 4:30
pm I will pull data from cells B. I need a time reference to till me when to
switch cells.
4:30 pm to 7:00 am I will pull data from cells A and from 7:00 am till 4:30
pm I will pull data from cells B. I need a time reference to till me when to
switch cells.
M
Myrna Larson
The TIME function gives you the current time....
The time will be used to determine what set of cells I pull data from; from
4:30 pm to 7:00 am I will pull data from cells A and from 7:00 am till 4:30
pm I will pull data from cells B. I need a time reference to till me when to
switch cells.