I want to create a sheet for use in a Contact Centre to record when
people are being allowed off the phones to do other work.

My objective is a three column sheet (with addition columns for text)
where, if a person enters a start time value in column B and and end
time value in column C, the system time (when the entry in B was made)
appears in column A, but as a fixed and not as a volatile value.

This is necessary so that we can see not only the time the person is
recorded as having done the work, but the time we are informed about
them starting! It may appear semantic but if we are told at 8pm that
someone was working on a project from noon until 1300 then we would not
allow that "exception" to go through and we need to know in real time.

Can this be done?

Thanks in advance and apologies if I am posting too much detail or in
the wrong forum.

Hillheader


--
Hillheader
------------------------------------------------------------------------
Hillheader's Profile: http://www.excelforum.com/member.php...o&userid=30644
View this thread: http://www.excelforum.com/showthread...hreadid=503040