Timesheet report showing overtime hours ...

[JohnSe1]

Hello hivemind What I assumed was a simple report - is becoming a thorn in my side. Looking to produce a report that shows how many overtime hours a person has submitted towards their timesheet items. Built a timesheet report with the following filters: Timesheet -> Timesheet Profile ID = <> Hour -> Entry Date < Overtime Hours - Greater than equal to <.5> Problem is on my reports it's collecting the users multiple tasks each with their combined hours for all tasks on said timesheet -- Example User A has 3 tasks each with 3 hours tagged. On the report it lists each task like it should, but shows each task with 9 hours... What am I doing wrong :-) ESPN John.W.Seitz@disney.com

[tracy_fox]

John, I haven't used this report in quite awhile, but within it I have the following textmode. Maybe it will help? displayname=5 day work week Calc OT Hrs linkedname=direct namekey=totalHours querysort=totalHours textmode=true textmode=true valueexpression=IF({totalHours}>37.5,({totalHours}-37.5),0) valueformat=HTML Tracy Fox Project Manager / Workfront SysAdmin Sykes Assistance Services Corporation