XEmployeeHours
XEmployeeHours - Hours paid to employees
Description
This function is only available for Sage 50 Canadian edition
This function returns the sum of hours paid to an employee.
Parameters
Employees [Optional]
Employee name.
Beginning [Optional]
Beginning date of the period.
End [Optional]
Ending date of the period.
Income types [Optional]
Income types.
Projects [Optional]
Project to which hours were allocated.
Connections [Optional]
Sage 50 Connection to query. If left empty, the default connection will be used.
Examples
It is strongly recommended to utilize Excel cells address (ex. A1:B19) containing the information of the parameters requested in all Logicim XLGL functions, such as accounts, dates, departments, vendors, customers, employees, etc. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.
Returns the sum of hours paid to an employee in July
=XEmployeeHours ("Ashcroft, Howard L.", "July")
Posted: Tuesday, November 05, 2024
Related articles
No related articles found
You can Contact us so we can address your question.