How can I use a character such as T to enter time into a cell? It works in healthcare and in our patient tracking system we can type T and it will enter the date or N to enter the time. I also would like to know is it capable for a cell to change color once the stop time is entered. (This bring awareness that the patient is ready for registration)?

​How can I use a character such as T to enter time into a cell? It works in healthcare and in our patient tracking system we can type T and it will enter the date or N to enter the time. I also would like to know is it capable for a cell to change color once the stop time is entered. (This bring awareness that the patient is ready for registration)?  Read More

​