Software·43,925 discussions

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

Tags: Microsoft

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?

Topic

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

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

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!!

[Author]

Replies