Need to calculate total times in Excel

I have a series of dates with transaction times within those dates - I need to calculate how much time was spent on each date and the total time spent over the date series and then include in a pivot table along with the