Try ERPNext Buy Support Partners Foundation

Get Total Working Hours In Query Report

Hey Hello Guys Can anyone help me When i do something about query but not result found please give me the solution about that Thankyou i am waiting check in time and check out time i need total working hours.

i do this Query in my report but not exactly generate this report

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

Hi welcome to ERPNext

This post continues here

and here too