Report weekend and holiday hours worked

  • 1
  • Question
  • Updated 2 years ago
  • Answered
Our regular business hours are Mon - Fri and we have most holidays off. But certain departments may have individuals working on weekends or on holiday. We would want to be able to capture this information on a report, where we can just filter by who put hours on weekends and holidays. 
Photo of Duran Galvis, Andres

Duran Galvis, Andres

  • 3 Posts
  • 0 Reply Likes

Posted 2 years ago

  • 1
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1522 Posts
  • 106 Reply Likes
Hi Andres,

Thank you for using the Replicon Community!

We can help you create a custom column that lists out the Day on which the time was entered. You can then export the report to excel and filter the weekends. You can also add a time off hour and time off type column that can help you understand who took a holiday off. The report will look as follows:



Please let me know if this works well for you. I can then provide you with the custom column formula and report details

Thanks,
Aashnee
Photo of Duran Galvis, Andres

Duran Galvis, Andres

  • 3 Posts
  • 0 Reply Likes
yes could you please provide the details.
Photo of Aashnee Kamboj

Aashnee Kamboj, Community Moderator

  • 1522 Posts
  • 106 Reply Likes
Hi Andres,

Thanks for the confirmation. Please follow the below steps:

  • Go to Reports and add a new report
  • Choose Category as Timesheet and Report Type as Timesheet Day Template
  • Select User Name, Entry Date, Hours Worked, Time off Hours, Time off Type as columns



  • Switch to "Custom" tab 



  • Name the custom column and input the following formula
    (IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))>3,(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=6,"Saturday" 
    ,if
    ((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=4 , "Thursday" , 
    "Friday"))),(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))>=0 
    &&
    (MOD((Daydiff((date(1990,1,7)),EntryDate)),7))
    < 3 ,(IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=0 ,"Sunday" ,
    IF((MOD((Daydiff((date(1990,1,7)),EntryDate)),7))=1 , "Monday" ,
    "Tuesday"))),"Wednesday"))))



  • Click on Create
  • Choose the Entry Date filter and click on Done Editing



  • Apply the filters and run the report
  • Save the Report by clicking on the Save Button for future use
  • You can Group the report by User Name or any other entity by clicking on the Settings button and changing the Group Rows by Value
Thanks,
Aashnee