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...
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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
