View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] areed@penobscotnation.org is offline
external usenet poster
 
Posts: 2
Default Comparing current time to a particular cell

I am trying to generate a reminder for our laboratory analyst to
perform a certain task with our samples at a particular time. The time
at which she needs to do this task (end time) will be in a particular
cell. This end time is based on the addition of 2 hours to another
cell that contains the start time.

So I would like to add the current time to a different cell and have it
be frequently updated using the computer's clock. This will give me
something to which I can compare the time described above. I need this
same event to occur over multiple worksheets but only happen on the one
being currently used.

Thanks so much for any help that anyone can provide!