I have a spreadsheet with data in the following order:

Date Time Day Open High Low Close Volume

There is a value for each minute of each trading day for a little over 3 years. I'm trying to create a new table that shows the date, highest high, lowest low, sum of volume, time of highest high, time of lowest low. I've been trying to do this with pivot tables.

My current pivot table shows the date, highest high, lowest low, sum of volume but I can't figure out how to also get the time that these two events occurred. Any help would be greatly appreciated.