Hi,
i am working on a Shared workbook that will track time taken to complete tasks.
i have a Status Column - M, i then have a Started at Column - N and a Finished at column - O.
The started/finished at column has a formula that enters a time stamp based on the following statuses - Ongoing/Completed.
=IF(M4="Ongoing",IF(N4="",NOW(),N4),"")
My issue is that once the status has changed from Ongoing to Completed the start time disappears. is there a way (im assuming it will use VBA) to save the data entered into the columns so i can record the time taken to complete the task. id then like to protect the cells from being edited by the operator.
Any help would be much appreciated.
i am working on a Shared workbook that will track time taken to complete tasks.
i have a Status Column - M, i then have a Started at Column - N and a Finished at column - O.
The started/finished at column has a formula that enters a time stamp based on the following statuses - Ongoing/Completed.
=IF(M4="Ongoing",IF(N4="",NOW(),N4),"")
My issue is that once the status has changed from Ongoing to Completed the start time disappears. is there a way (im assuming it will use VBA) to save the data entered into the columns so i can record the time taken to complete the task. id then like to protect the cells from being edited by the operator.
Any help would be much appreciated.