View Single Post
  #6  
Old June 4th, 2010, 05:03 PM posted to microsoft.public.excel.newusers
FloMM2
external usenet poster
 
Posts: 189
Default What Excel formula converts hourly wage to annual salary

Entre Nous,
You will have to make a few assumptions:
1. full-time is equal to 40 hours per week
2. there are 52 weeks in a year

Once you have done that, it is simply hourly rate times 40 hours times 52
weeks.
"=(A1 *2080)", if cell A1 has hourly rate in it (2080 is 40 times 52).
hth
"Entre Nous" wrote:

I need help creating a simple formula that converts an hourly wage to an
annual salary.