Formula to determine last job of the day

I have a dataset of engineers with jobs they have completed everyday since April 1st. There are two columns with their start/end date/times in the format dd/mm/yyyy hh:mm. There is also a column with just the date completed.

Is there a formula I can use to tell me of all the jobs they completed each day which one was their last?

I just need to mark these jobs with a Y so I can then take the average times for these jobs.