XEmployeeHours

XEmployeeHours - Hours paid to employees


Description

Sage 50 Canadian Edition  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")

Edited: Thursday, January 09, 2025

Was this article helpful?

Thank you! Your feedback matters.

We'd love to hear your thoughts! Please provide a comment before submitting.

Thank you for your message!

Would you like a Logicim team member to reply to your message?

If so, please enter your email address below.

You will also receive a copy of your comment.

We protect your personal information.

Thank you for your message!

Verify your inbox or spam folder to find the copy of your comment.
Contact clientcare@logicimtech.com if you didn't receive it.

Related articles

No related articles found

Can't find what you're looking for?

You can Contact us so we can address your question.