Can someone please help
I have attached a section of my timesheet report that come from SICON, the report shows the hours worked in each day on different elements for each week of the month.
When I pivot rather than show 8hrs is represents 1/3 (0.333) of a day, I would like to be able to convert the sheet into actual hours worked and pivot this.
I need to report of the hours worked by each member of staff for the month, also hours on each project for the month.
best regards
Dave