Annunciator alarm time stamp

=?Utf-8?B?V2FzdGV0b0VuZXJneUppbUpvaG4=?=

Guest

Posts: n/a

31st Aug 2007

I have 10 rows of annunciator messages

col A will be timestamp
col B will be static annunciator message
Col C will be either 1 or 0 and constantly updated for another remote program

The Col C data is constantly being re-written with new data, even though the
bit status may not change

when I use =IF(C3=1,NOW(),"")) command the time is updated each time the
cell is rewritten. I need the time to remain locked until the remote program
changes the 1 to 0 even though the 1 may be rewritten many times.

« cleaning up text macro by Alan Barasch | Resize the radio button »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I change the email time stamp to match my computer time?	DonnaP	Microsoft Outlook Discussion	1	30th Jan 2009 10:16 PM
Comparing 2 files on date/time stamp, and based time difference do a subroutine	info@stevik.nl	Microsoft Excel Programming	1	28th Sep 2007 03:53 AM
Outlook should use actual time message sent as time stamp for head	=?Utf-8?B?Y2FybHRvbg==?=	Microsoft Outlook Discussion	0	20th Jul 2006 11:04 PM
Saving codes source file date-time stamp for run-time use	=?Utf-8?B?a2VuQG5vc3BhbS5ub3NwYW0=?=	Microsoft Dot NET Framework	4	24th Jan 2005 05:32 PM
Invalid date time stamp error every time winxp pro boots	Harp	Windows XP Setup	2	18th Jul 2004 07:01 PM