Show total number of hours logged per day, per person

We are working with a timesheets app where everybody adds there hours. I am looking for a way to calculate (and show) the total amount of hours worked per day, per person. Just so eveybody has an easy overview of the hours worked and can see if they logged 8 hours that day.

So far I have only found solutions for adding up the hours for complete projects, or specific date ranges or costs for a project.

As I see it, it would be a field on the time sheet that calculates other hours worked on the same day using: @Tijd (time spent) @Datum (date) and @Gebruiker (user). I could also show this value in the overview of all timesheets an reports so we can see if people are logging (too much or any) overtime without doing any other calculations

Heather Fox

February 18, 2016 00:39

Hi, Chris. You can build a report that shows that information.

In your Timesheet app, set Filters to show only those items whose Date is "Today" or "Yesterday".

Create a Report with the following parameters:

"Calculate for each item Time Spent then show the sum per User"

This will give you an overview of the time spent by user for the current day/yesterday as well as total hours across users for the day.

Hope that helps!

Heather

Chris van den Ende

February 18, 2016 08:45

Hi Heather,

Thank you for your response, but I would like to show this in the timesheet app itself and not in a report.

I have added the report, and this is what I needed. Now I just need a way to show this directly in the timesheet app

Show total number of hours logged per day, per person

Comments

Didn't find what you were looking for?