Get Employee Total Working Hours (Missing)

kartik · December 9, 2019, 12:49pm

In the Attendance doctype listview, on the left sidebar, click on Report Builder.

Click Menu button on right side
Pick Columns
Check working hours option in the popup and click submit.
Refresh report. You should now have a column with working hours.

Salman_Tah · December 9, 2019, 1:01pm

kartik can you help me

kartik · December 9, 2019, 3:33pm

Please post your query.

Salman_Tah · December 10, 2019, 10:30am

Select
c.name as “Attendance Name:Data:150”,
(select employee_name from tabAttendance where name = c.name) as “Employee Name:Data:120”,
(select department from tabAttendance where name = c.name) as “Department:Data:120”,
(select check_in from tabAttendance where name = c.name) as “Check in Time:Data:50”,
(select check_out from tabAttendance where name = c.name) as “Check Out Time:Data:50”,
(select working_hours from tabEmployee where employee = c.name) as “Working Hours:Currency:80”

from tabAttendance as c . I need check_in check_out get total Hours working brother

kartik · December 10, 2019, 10:40am

This might not be possible with query report. You will have to create a custom report.

clarkej · December 10, 2019, 3:19pm

See also Query Report - Query report Path on Server Side

Salman_Tah · December 11, 2019, 10:47am

Ok thankyou, Can you help me what i should start Custom report can you help me to this

clarkej · December 11, 2019, 4:05pm

This notes the three Custom report options you could use https://erpnext.com/docs/user/manual/en/customize-erpnext/articles/making-custom-reports-in-erpnext

So if neither the Report Builder nor Query reports meet your needs, your third option is to develop a Script report

Salman_Tah · December 12, 2019, 10:07am

Thankyou for this, can you guide me how to develop Cumtom Script report

tuguldurdmt · February 6, 2020, 8:53am

Hello, If there is only one log from employee checkin log how can i calculate and put value in total working hours as like half day of 4 hours. There is settings in shift type is if status is half day put work hour in 4 but when auto attendance in generated after working hour value is 0 !

Raymond_Liew · February 6, 2020, 10:19am

I know this is out of your question, but would you mind to share how you customize for the “Working Hours (min)”, “Over Time (min)”, “Late Entry (min)” and “Early Exit (min)” calculation?

kartik · February 6, 2020, 11:54am

These settings are part of Shift Type doctype. After enabling mark auto attendance, these settings section will be displayed.

tuguldurdmt · February 7, 2020, 2:20am

All these calculation of field is custom coded in server side of processing auto attendance in shift type py and employee checkin py

iMoshi · February 7, 2020, 3:00am

@tuguldurdmt welcome.

We need to look into “Timesheet” as well.

ahmedalisync · February 20, 2020, 9:51am

Hi all ,
Thanks for your efforts.
I want to know why all work hours is 0 although there are check ins and check outs
Thanks in advance
Ahmed Ali

tuguldurdmt · March 10, 2020, 2:49pm

Because it was only one attempt from log file. If any of employee make only once attempt tried in working day there is only one log file will come at program so it can not calculate working hours thats why its makes 0 value throws back

Hana_a_Salah1 · March 31, 2020, 6:31am

Hi
I’ve tried this , but the working hours shown as 0

higuain.20 · April 8, 2020, 7:03am

hi everyone, where the “working hours” variable come from?

is it from Employee Check in?

Reema_Mehta · April 8, 2020, 7:26am

@higuain.20

You can see the working hours from the attendance logs. Go to Attendance → Report builder → Pick columns & save. Kindly check the screenshot below:

Regrards,
Reema

higuain.20 · April 8, 2020, 9:22am

Thanks Reema for the answer, yes i can find WH there, but the amount is 0, even though i already set the shift type (8:00-17:00)…

actually i want to use WH variable to do Formulate in Salary Component…