Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update current time automatically?
Hi! DOes anyone know how...if it is even possible... to display the CURRENT time in a worksheet automatically? I am using the "now" function, but in "help" it says the time will not update unless "the worksheet is calculated" or when a macro is run. I need to be able to just have this page up throughout the afternoon and have an alert message pop up 15 minutes before a "promised completion time" without having to do anything in the workbook. Is this possible? Any feedback is greatly appreciated!! thank you! -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=391063 |
#2
|
|||
|
|||
Seems to me what you really need is to set an appointment in Outlook calendar and have it bring up a reminder at your desired time. Much easier and uses less system resources than leaving an Excel workbook open with a macro running all day long (and it would take a macro running all day to do what you ask). HTH -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=391063 |
#3
|
|||
|
|||
oh shoot! :) well, I do need to do it in Excel becasue there are other conditional formulas tied into all this as well...i only need the timed ones to pop up 15 minutes before if it meets 2 other criteria as well...plus this is a fairly large workbook shared by 8 other users, blah, blah, blah...i'm sure that makes little sense, sorry! Anyways, you still answered my question, Bruce! Can't be done! I'll have to just watch the clock! :) thank you so very much though, i really appreciate your expertise!!! Take Care, Jenny (also from Minneapolis by the way!) -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=391063 |
#4
|
|||
|
|||
You can read about the scheduling procedures at Chip Pearson's site:
http://www.cpearson.com/excel/ontime.htm You could schedule a macro that just recalculates (over and over and ...) (I, too, wouldn't do this. But good luck if you do!) JENNYC wrote: Hi! DOes anyone know how...if it is even possible... to display the CURRENT time in a worksheet automatically? I am using the "now" function, but in "help" it says the time will not update unless "the worksheet is calculated" or when a macro is run. I need to be able to just have this page up throughout the afternoon and have an alert message pop up 15 minutes before a "promised completion time" without having to do anything in the workbook. Is this possible? Any feedback is greatly appreciated!! thank you! -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=391063 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using "IF" and "AND" statements with current time | Excel Worksheet Functions | |||
how do i automatically insert the current author's name in a cell. | Excel Worksheet Functions | |||
How do you continuously update time and date in an Excel cell? | Excel Worksheet Functions | |||
How to continuously update time in Excel? | Excel Worksheet Functions | |||
How do I set my webpage to automatically update a changing spread. | Excel Discussion (Misc queries) |