I am new to spreadsheets!
I have created a google form to track a service technician’s daily time record. The technician might visit multiple sites in a day. As Forms does not allow looping questions, I have had to create a number of duplicate sections.
The Google Sheet attached to the form is here:
https://docs.google.com/spreadsheets/d/1zzivoIt2gfrb21mRpE2sbiZA37hc-sLUYgDT74qcf6Q/edit?usp=sharing
I am wondering if anyone can explain to me how to build a formula that will give me the “Daily Finish” time (“Processed Data” Sheet, Column “AS”) from the last recorded “FINISH” time in the row?
I have tried using XLOOKUP but that only gives me the data from either the first or last “Finish” column, not the last “Finish” column with data, ignoring blank cells
WiltechService is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.