LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CURRENT TIME IN DESTINATION CELL IF SOURCE CELL IS TEXT Thomasel Excel Discussion (Misc queries) 3 April 15th 08 11:19 PM
cell with static current time ben w Excel Worksheet Functions 8 September 8th 07 02:42 AM
Check box, then add current time to cell Joe Excel Worksheet Functions 5 January 9th 07 12:25 AM
Having the current time inserted w/o updating the current time sherobot Excel Worksheet Functions 2 October 2nd 06 05:05 PM
current Date and time in cell Alex01 Excel Discussion (Misc queries) 3 February 24th 06 09:22 PM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"