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 / 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.
3 Replies
- 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?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.
