Calculate start & end times in an EXCEL table with multiple dates and times
Ok so I’m killing myself trying to find a solution to this. I have an excel sheet with column headers Date, Start Time, End Time
Under the headers are hundreds of rows – for example for one day I may have 10 rows all with the same date but with different timings.
I need to create a table that automatically generates a single row for each date showing only the start time and the end time for that date.
Ideally I don’t want to use any coding – is there a method out there I can use?