This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi Community- I am stuck! I need to create new columns (First Start Time/Last End Time) that only have the highlighted fields in columns C&D populate into columns E&F. The issue is that sometimes there are multiple times per person within a given day, but I only need the first start time and last end time per day. Is there a way? I’m leaning towards sorting.
Do you actually want to create the duplicate rows for situations where there is more than one start/end time?
If not, you should try the summarize tool - group by name & date, and then select minimum start time and maximum end time, which should give you one line for each person/day combination with the earliest start time and latest end time.
If you want your data to keep the original number of rows, you could then join the above data back to the original data by name & date, and then you'd have both the original start & end times as well as the earliest start and latest end time for each row of original data...