I need to have a time sheet summary report for a group of employees. I can show their single entry task hours and planned hours, but not summarized by the various hour entries - task hours, PTO, overhead hours, etc. in total for the time period.
Also, the planned hours are not for the report duration (e.g. one week) but are rather for the entire task duration - so it shows up as individual task line items with the TOTAL planned hours on every single line. (if the person has multiple entries for the same task over the course of a week, it will show the same total every single time so that it looks like they were planned to work way higher hours in the week instead of 40). -- Bob - 2 hours - planned 20 hours; then next line Bob - 1.5 hours planned 20 hours (in the end, it looks like Bob worked 40 hours but was planned to work double or triple that amount due to the double counting)
Ideally I want the report to say
Name -- total hours entered ---- total hours planned ---- total Task Hours --- total Admin Hours --- total PTO Hours
Does this not exist in WF? I cannot find it on any of the reports - and each of our efforts at building one has failed.
Thanks!!
