Hi I have a report where I have to get the employees absence hours, i.e if there are 8 hours in a day and the employee worked for 5:50 minutes then the difference would be calculated in time.... Please also let em know how to calculate absence hours if the
working ours are null as its not showing any value for absence column
WorkingHrs HoursWorked Absencehours
8 5.10 2.50
8 Null Null
I have query that I have written to get the absenceHours= WorkingHrs - HoursWorked
Please help I feel its a simple query but kinda confused with it. Thanks.
View Complete Post