Conditional formatting help please!

[Malin Jaworski]

I know there are like a thousand of these but I couldn't find anything similar to this.

I have a spreadsheet with 8 columns (infinite rows):

DATE / RACK NUMBER / SAMPLE START / SAMPLE END / TIME IN / SIGN / TIME OUT / SIGN

I need the DATE column to generate the current date and I need the TIME IN column to generate the current time when a value is added to SAMPLE START (value example: 19AA500111. And yes it has to be both latters and numbers)

So far I've tried the IF function but I can only get it to spit out TRUE/FALSE and not the actual date.

[#2]

I am not sure what you want to accomplish.

If Time In is a value generated by a formular, its value will be changed when you open the workbook next time. Is it what you want?

[#3]

I want the current time and date to be generated (in different columns) when I add a new value to Sample Start.

It's a log that is continually being added to several times a day.

It should look something like this:

Date	Sample start	Sample end	Time in	Sign	Time out	Sign
2018-01-22	18AA500111	18AA500222	10:55	MJ	12:00	MJ
2018-01-22	18AA500223	18AA500240	12:05
2018-01-22	18AA500241	18AA500245	13:00
2018-01-23	18AA500246	18AA500300	10:00

The date and time in is generated when a sample is scanned into Sample start. Sign and Time out is written manually.

A log like this would lessen the risk of getting a sample number wrong when writing by hand, as we're doing now.

[#4]

This may need a solution with VBA. Formula will always give you a dynamic values. Today/Now function will update its value every day. The Time in column of your spreadsheet should get a timestamp which will not be changed whenever you open the workbook. Hence, you need a VBA solution to input the timestamp in the time in column.