How to reformat annual wages as hourly wages

[Ceichhorn]

Hi all,



Hopefully a simple question: is there a way to convert annual or monthly wages in to hourly wages if I have the Annual Wage and Hours worked per week? I can brute force this if necessary, just hoping there is some sort of built in function.

[ranman256]

in a query make a new field to divide:
HrRate: [annualRate]/365

[JoeM]

in a query make a new field to divide:
HrRate: [annualRate]/365

Seems to me that would return a Daily rate, not an hourly rate (since you are dividing the annual wages by the number of days in a year).

If you had an Annual Wage and Hours worked per week, if you assume a 52 week work-year, then your hourly wage would look like:

HourlyRate: [Annual Wage]/([Hours worked per week]*52)