Forum Discussion

HenrikH29's avatar
HenrikH29
Advocate I
9 years ago

Problem calculation total work hours

I need to calculate the total work time per employee for a given period (ie month).   Our employees have a normal work time calender with a daily work time ie 7.5 hours monday to thursday and 7 hou...
Need Help
ceebu's avatar
ceebu
Advocate I
9 years ago

You can easily add the Active status of the employee to the filter (visual filter or page filter or report filter) to achieve the desired result.

 

I added a new table with the Status Fields, and created a few employee records with Inactive status.

 

 

Then, I added the Status as a filter in the visual:

 

 

See the result with / without the filter.

 

 

Download the Updated PBX file here -

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm having some troubles with calculating total time for a column. My data has Name, Date, Start time, Finish Time, Lunch break, Total hours work, Total hours (hh"mm), comment. My data came from spreadsheets with stuff worked on them and all I had to do was change time to duration or time and filter out the spreadsheets that I didn't want from a folder and other information. I have a slicer with these filters, Name and Date = relative date is in the last 1 calendar weeks. I have a total hours work Total but I wanted to try a Total hours(hh:mm) Total for the same filter date=relative date is in the las 1 calendar weeks. Is this possible? I just want a simple calculation to add the Total hours (hh:mm) column. So that total should read 20.30 next to the 20.50 total.

Thanks!