Zend certified PHP/Magento developer

How to Sum Task-Specific Timesheet Table by Date?

I am manually filling a timesheet in an Excel table, each row being for a project task, for example:

project task; time, date, notes; time, date, notes

I would like to output a table of: Date, Sum of Time. I suspect this can be done using pivot tables but have not been able to figure out how to do this. Thank you for the help.