macro_man
04-03-2009, 08:10 AM
I have a very strict morning routine that I have set up in Excel that allocates the morning's time for each task before I leave for work. I would like to have a digital clock displayed on the same worksheet as the schedule to monitor my progress. I have downloaded clocks that display on the desktop but would prefer it be on the Excel worksheet. I can put in =now() and set up a looping macro to continuous calculate the cell, but that seems like it would not be good for the computer system. Is there a better way?
In a separate macro would there be a way to prompt a sound whenever a task should be complete so I can move onto the next one.
Each task is set up with a start time and and end time based on the number of minutes allocated for each one such as ...
4:50AM - 5:05AM 20 (minutes) ... lift weights
5:06AM - 5:21AM 15 (minutes) ... shower
Thanks for any assistance you may provide. This is a great site!
In a separate macro would there be a way to prompt a sound whenever a task should be complete so I can move onto the next one.
Each task is set up with a start time and and end time based on the number of minutes allocated for each one such as ...
4:50AM - 5:05AM 20 (minutes) ... lift weights
5:06AM - 5:21AM 15 (minutes) ... shower
Thanks for any assistance you may provide. This is a great site!