I'm trying to track manfacturing productivity between day and swing shifts.
I was hoping there was a function that would give the current date and time
WHEN a cell = x which will designate a task is complete. I've got a list of
tasks that are performed and as I mark them off as complete with an "x" I
would like a different column to display the date and time that each one is
checked off instead of manually entering this as things are completed. Help
anyone?

Thanks in advance...