I want a code in app script for google sheets, that records a (start time) time stamp when a value named ” بإنتظار وصول وثائق الزبون” is selected in the dropdown menu and then when it is no longer the selected value, to record the (end time) time stamp. But get this, the drop down is in a sheet called “Work Sheet” in column K3 and the time stamps have to be recorded on a sheet called “Data” in Column P3 (start time) and the (end time) in Q3.

PS. I have zero coding experience but I know this is a feature I need so I will be very appreciative if someone can help with this.

I tried to use chatgpt but it does not work.