#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default CONVERSION

HOW TO COMPUTE A MONTHLY PAID SALARY TO AN HOURLY AND OR DAILY PAY
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conversion [email protected] Excel Discussion (Misc queries) 0 August 6th 06 10:15 PM
Conversion Duke Energy Excel Discussion (Misc queries) 0 January 24th 06 09:30 PM
pdf conversion Pat Excel Worksheet Functions 2 July 1st 05 12:53 AM
Between conversion Dan Wilson Excel Worksheet Functions 0 March 13th 05 03:02 PM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"