Excel 2007/2010 Macro to sort spreadsheets

I would like an Excel 2007/2010 Macro to sort spreadsheets like attached “Time-Unsorted” to “Time-Sorted”. In short this involves the following steps: Sort by date; oldest to newest Group all dates together and add row beneath each group Add all Hours from one group together and place total in new row as indicated Change color of total hours, for each group, to red This should be a macro that can be loaded and used in any MS Excel 2007 or 2010 workbook. Thank you.