How do I get the weekly total of hours for multiple daily timesheets?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I'm trying to set up a timesheet report and need it to output the total hours worked in one week (per employee) after each employee would input there daily hours.

How do I get Hours Worked Per Hour formula to do so?

Photo of Hannah

Hannah

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QB_Support_Brian

QB_Support_Brian

  • 40 Points
Hi Hannah,



A formula field is able to manipulate data within a single record, but is not able to work with data from multiple records. I think the most straightforward way to do this is to build a table report filtered to only show timesheets from the current week.  From there, you can group the timesheets on the employee (by choosing 'sort and group from low to high' by the employee name, in the Sorting & Grouping section of the report settings), and you'll see the weekly totals in each section.



Thanks,

Brian