How to copy excel data to google sheet (Copying particular rows based on the common column in both excel and Google sheet)

Hi i have a scenario in which

i have an excel sheet that contains Employee id, in time, out time


in which i have to add in time, out time, work duration to the below google sheet based on the employee code

please help me on writing conditions for this scenario . Thank You!!

1 Like

hi any idea…??