Hi Excel Pros,

This is my first time to join the excel forums and have seen how helpful you guys are here.

I need to come up with a visual basic code that would able me to click (single click) a specific cell to populate the current time.

Lets say for column A that's where the tasks would reside and column B,D,F,H would be the start time columns while C,G,E and I would be the "end time" columns. It would look like there would be simultaneous timers for each row. Columns L will sum up the the difference of all start/end time columns to show the total time spent.

Conditions are:

-Time should be hh:mm:ss

-Lets say for row 2, a2 would be the task name, once I click b2 (start time), it will populate the current time. Once the employee is done doing the task he may now click on c2 (end time) to populate the current time to show end time. Or if he wants to continue the task, he may click on d2 to start the timer again and e2 to end it and so on..

-the first end time column would not be populated (if accidentally clicked) if the start time column has no time populated in it.

-the start/end timers will not be populated (if clicked) if the prior set of start/end timers are not populated yet.

-if a timer cell is populated, the employee would not be able to amend that time populated (password protect).

It would look like this:

TASK |Start Time| End Time |Start Time | End Time |Start Time | End Time |Start Time |End Time
Task 1 | | | | | | | |
Task 2 | | | | | | | |
Task 3 | | | | | | | |
Task 4 | | | | | | | |
Task 5 | | | | | | | |
Task 6 | | | | | | | |
Task 7 | | | | | | | |
Task 8 | | | | | | | |
Task 9 | | | | | | | |
Task 10| | | | | | | |

Your help will be very much appreciated

Thanks,
JUS