shantraj.antin@gmail.com
Member
Hello Sir,
I am working on time study template. In the attached file I have 2 command buttons "Start and End" to capture current "Date and Time" and calculate the TAT. I have added command buttons for each row and macro is assigned to each button.
With this method macro code is too long if I need to capture 20 + line items. I am looking for to work this template with only 2 buttons as start and end which continues to capture time in column D and E for the next blank cells.
Also I would like to put the color code for TAT value as per the below conditions
between 00:00:01 and 00:09:59 ==Green
between 00:10:00 and 00:19:59 == Yellow
Greater than 00:20:00 == Yellow
Kindly help me on this problem. Thanks in advance for the support.
I am working on time study template. In the attached file I have 2 command buttons "Start and End" to capture current "Date and Time" and calculate the TAT. I have added command buttons for each row and macro is assigned to each button.
With this method macro code is too long if I need to capture 20 + line items. I am looking for to work this template with only 2 buttons as start and end which continues to capture time in column D and E for the next blank cells.
Also I would like to put the color code for TAT value as per the below conditions
between 00:00:01 and 00:09:59 ==Green
between 00:10:00 and 00:19:59 == Yellow
Greater than 00:20:00 == Yellow
Kindly help me on this problem. Thanks in advance for the support.
