Static Data

Hi!

Is there any way to convert a result into a static data once it meets a given condition? I have been working on a worksheet that records a person's entry and exit inside my workplace. I'm using a barcode scanner because it's faster.

For example,
I logged in 8:00am and scan my ID. The worksheet then shows me my name, the date, time, and day, then tells me that I have logged in. The formula works fine at the first instance. Then at 12 noon, I scan my ID again. The worksheet tells me that I have logged out. The frustrating part is, the first instance also changed, displaying both "out". What I am wondering is how to make the first instance stay as "In" instead of "Out". I've been searching the web for answers for a week now but to no avail. I want to overcome this hurdle guys, I hope you could help me.

I want to see this
Name Time Date Day Type of log
Andrei 8:00 am 23/11/15 Monday In
Andrei 12:00nn 23/11/15 Monday Out

instead, I get this:

Name Time Date Day Type of log
Andrei 8:00 am 23/11/15 Monday Out (the first instance changed)
Andrei 12:00nn 23/11/15 Monday Out

Hi Ford,

Thanks for the response , that was fast . No, they don't come from the scanner. The barcode scanner just scans the id and the worksheet shows the information from the scanned ID then shows the time. The Date and time uses VBA code.

Hmmmm.. not sure how to answer that. I'm sending you a sample of the worksheet.