ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   CONVERSION (https://www.excelbanter.com/excel-discussion-misc-queries/142435-conversion.html)

L8F8AT48

CONVERSION
 
HOW TO COMPUTE A MONTHLY PAID SALARY TO AN HOURLY AND OR DAILY PAY

JE McGimpsey

CONVERSION
 
Depends on what you mean...

In the US, exempt employees get paid a salary regardless of the number
of hours worked, so by one convention, an equivalent hourly rate is
calculated based on 52 40-hour weeks:

=<monthly salary*12/2080

and the daily rate would just by 8 times that.

If you want something else, I would need more information - do you want
to calculate for a particular month (since number of days vary)? Do you
want to count M-F, 8 hours per day? Do you want to take into account
holidays?

In article ,
L8F8AT48 wrote:

HOW TO COMPUTE A MONTHLY PAID SALARY TO AN HOURLY AND OR DAILY PAY



All times are GMT +1. The time now is 02:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com