Avergae Hours Inclusive of Holiday and Sickness

Chantal Chandler

• February 27, 2024 20:05

I am looking for an average hours report over 52 weeks that includes holiday hours and sick leave hours. The only reports I can find do not include these and therefore are not an accurate reflection of hours worked? Thanks

0

Download Our App

Comments

5 comments

Sort by Date Votes

• 

  Sam Spencer

  • February 28, 2024 15:25

  Hi Chantel,

  I hope you are good!

  Average Hours worked can be found as a field within Custom Reports (HR > Reports > Customised Reports > Create Template > Report Group - Employee Details). In order to filter by location (Report Group - Employee Work Details), you should use the below Condition (=), which will allow you to filter by location:
   
  Alternatively, you could run the Employee Hours Worked Export found in the Rotas Module, which will allow you to filter by dates, however will not show the average hours worked but rather the total hours.
   
  I am attaching a knowledge article on how to run Custom Reports in both HR and Payroll:
  https://help.hotschedules.com/hc/en-us/articles/360058062212-WFM-UK-UI-Refresh-HR-and-Payroll-Custom-Reports

  I hope this helps!

  0
• 

  Chantal Chandler

  • February 28, 2024 16:20

  Hi Sam, 

  Thanks for coming back to me! Are you sure this includes holiday hours and sick hours as I have taken a look and I wasn't sure it did?

  Thanks

  C

  0
• 

  Nikita

  • February 29, 2024 10:20

  Good morning, 

  Thank you for your reply. 

   

  The custom report should include all the hours that are on the rotas for the period of time this is ran for. So as long as there are hours for their sickness/holidays on the rota, this should feed through to the report. 

   

  If you have any further queries, please let us know.

  0
• 

  Chantal Chandler

  • March 04, 2024 14:51

  Hi Nikita, 

  Thank you for coming back to me. 

  Please can I arrange a call to discuss as I have an example of a salaried employee who:

  • Average hours is clocking as 0
  • Rota this week : 52.5hrs
  • Rota > Reports > Exports > Hours Worked: 52.5hrs
  • Rota > Reports  > Exports > Detailed shift list including holiday hours: 52.5hrs

  Please can we arrange a call to discuss. 

  Thanks

  Chantal

   

  0
• 

  Nikita

  • March 05, 2024 14:44

  Hi Chantal, 

   

  Thank you for your message. 

   

  I have just sent you an email to arrange a call. 

  0

Please sign in to leave a comment.