Subtract 8 hours of work from result hours

[alhareri]

I want to subtract 8 hours of work of the Result of employee work hours
there is attachment

[June7]

The TimeWork value cannot be a string like 7:30. Needs to be decimal like 7.5.

So either fix the HoursAndMinutes() function to return decimal or do another calculation to convert the returned string to a decimal and subtract it from 8.

[alhareri]

hi
so do you have another calculation to convert my time .. please help
because i try several thing but isn't working
thanks

[azhar2006]

Try using something like

SELECT Tbl_TimeOutIn.SalaryNo, Tbl_EmpName.EmployeeName, Tbl_TimeOutIn.DateIn, Tbl_TimeOutIn.TimeIn, Tbl_TimeOutIn.TimeOut, Tbl_TimeOutIn.Writer, Tbl_TimeOutIn.HideTime, HoursAndMinutes([Timeout]-[Timein]) AS TimeWork, Tbl_TimeOutIn.HourTime, Tbl_TimeOutIn.TimeShift, HoursAndMinutes(1/3-([Timeout]-[Timein])) AS TimeNotWorking
FROM Tbl_EmpName LEFT JOIN Tbl_TimeOutIn ON Tbl_EmpName.salaryNo = Tbl_TimeOutIn.SalaryNo
WHERE (((Tbl_TimeOutIn.HideTime)=No));

[June7]

Really need decimal hours in query so values can be used in calcs, such as aggregating records. Calculate the HH:MM string in textbox on report.

Review https://www.accessforums.net/queries...urs-47434.html

[azhar2006]

Yes, said June7
https://www.accessforums.net/queries...urs-47434.html

[evander]

How about subtracting 8/24 from the total hours?