Forum Discussion
Conditional formatting help please!
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 / T...
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.
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.