Question

Calculate start & end times in an EXCEL table with multiple dates and times

By edpageuk ·
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?
Thread display: Collapse - | Expand +

All Answers

Collapse -

Calculate start & end times in an EXCEL table with multiple dates and times

by edpageuk In reply to Calculate start & end tim ...

I fixed it!!!! Used a pivot table and placed start time and end time in the values field and used the max and min functions - formatted using hh:mm and bingo it worked. Today has been a good day!!

Related Discussions

Related Forums