We would like the ability to create a True Time report that allows us to see total hours WORKED (not paid/unpaid Time Off or Holidays) based
We would like the ability to create a True Time report that allows us to see total hours WORKED (not paid/unpaid Time Off or Holidays) based on a particular Pay Code. Right now the True Time Detail Transaction Report does not allow us to total by Pay Code or filter for just hours worked.
2
votes
Amy Mundell
shared this idea
-
Lora Holman
commented
Have you tried using Data Mining? You can include the pay code and then set the range for Status to "IN" so that you exclude any TOF (time off or holidays) and lunch records. Then you could use Excel with a Pivot table to sum the hours worked over the time period of the report.