Quote Originally Posted by sturmy View Post
Thank you that's perfect! +REP. Would it be possible for you to explain how you did this in simple terms? I will need to replicate this for other members of my staff and for future employees.
Sure, create a pivot table by go to Insert and select PivotTable, then go to Design (on the Ribbon), Report Layout and choose Show in Tabular Form. to see how pivot table is arranged click anywhere within pivot table then go to Options (located on the Ribbon) and click on Field List and while you there click on the Date filed and on the Ribbon click Group Field and unselect averything and select Hours.