Need a report to display ALL clock ins and outs done in the Clock In/Out Timesheet

  • 2
  • Problem
  • Updated 3 years ago
  • Not a Problem
We use Clock In/Out Timesheet. We do not use Time Punches. I need a report that shows each clock-in and clock-out per day. So if an employee clocks in at 8AM and clocks out for lunch at 12PM and then clocks in again at 1PM and clocks out at the end of their day at 5PM, I need the report to show me ALL of these clock ins. The closest thing I have found is the Time IN - Time OUT report but is summarizes the entire day's clock in/out per user.
Photo of jmorgan.phipos

jmorgan.phipos

  • 4 Posts
  • 1 Reply Like

Posted 3 years ago

  • 2
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Hi,

Thank you for using Replicon community.

Using the report settings you can enable the Time In & Time Out columns which should give you the required data. Go to Report Settings > Under the Pre-Defined section > scroll down to Timesheet - By Day section and enable both these columns. I have provided a sample screenshot of the report settings page & the report which shows the Time In & Time Out. 



Screenshot of the Report using the Timesheet Day template which shows the In & Out entries. 



Let me know if this helps.

Thanks,
Lingaraj
Photo of jmorgan.phipos

jmorgan.phipos

  • 4 Posts
  • 1 Reply Like
Yes, but clock in and out again and then run the report again. You'll find that it summarizes the two sets of entries. Instead of seeing two clock ins and two clock outs, you will only see one of each. And therein lies my problem :(
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Let me check that.
Photo of jmorgan.phipos

jmorgan.phipos

  • 4 Posts
  • 1 Reply Like
Thank you! Your help is very much appreciated.
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
Yes, I was able to test this and see the same results as shown in the screenshots below:- 

Time punches:- 


Report shows the data as:- 


I even tried to enter different comments for each row, along with different custom field values which did not make the difference. I will get a clarification regarding this with the concerned product manager & escalate to the engineering if needed. 

Thank you for reporting the same. 

Regards,
Lingaraj
(Edited)
Photo of jmorgan.phipos

jmorgan.phipos

  • 4 Posts
  • 1 Reply Like
Thanks Lingaraj. You guys are the best!
Photo of Lingaraj Dharwad

Lingaraj Dharwad, Product Champion

  • 1100 Posts
  • 46 Reply Likes
I have received an update from the concerned product manager that you can get these values using a report created from 'Punch Timesheet template'. I have provided a screenshot of the same below: 



Let me know if this helps.

Regards,
Lingaraj