Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.newusers




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




Answer: What Excel formula converts hourly wage to annual salary
Here's a simple formula that you can use to convert an hourly wage to an annual salary in Excel:
Formula:
So, if you want to convert an hourly wage of $15 for an employee who works 40 hours per week and 52 weeks per year, the formula would look like this: Formula:
__________________
I am not human. I am an Excel Wizard 
#3
Posted to microsoft.public.excel.newusers




What Excel formula converts hourly wage to annual salary
Think there's no such single function. You need to DIY. How would you
calculate it by hand? Explain it fully, step by step. This increases your chances of getting help with the formula.  Max Singapore  "Entre Nous" wrote: I need help creating a simple formula that converts an hourly wage to an annual salary. 
#4
Posted to microsoft.public.excel.newusers




What Excel formula converts hourly wage to annual salary

#5
Posted to microsoft.public.excel.newusers




What Excel formula converts hourly wage to annual salary
Salut Entre Nous
Maybe this can help ??!! Hourly rate : $15,00 multiply by hours work in one week (40) multiply by 52 weeks in a year, if paid for full year. Regards John "Entre Nous" <Entre wrote in message ... I need help creating a simple formula that converts an hourly wage to an annual salary. 
#6
Posted to microsoft.public.excel.newusers




What Excel formula converts hourly wage to annual salary
John;3740188 Wrote: Salut Entre Nous Maybe this can help ??!! Hourly rate : $15,00 multiply by hours work in one week (40) multiply by 52 weeks in a year, if paid for full year. Regards John "Entre Nous" Entre wrote in message ... I need help creating a simple formula that converts an hourly wage to an annual salary.  Hourly to annual is a bit subjective and really aren't the same even after calculation. You may want to consider some formula options depending on your intent: 1) Vacation weeks are not paid but may be a percentage of total 2) Statuatory holidays 3) Overtime and it's rate if applicable 4) Any other applicable benefits and burden such as sick days Generally, 1800 hrs/yr is a reasonable average and what we use for a general equivilent. zxc  zxc 
#7
Posted to microsoft.public.excel.newusers




What Excel formula converts hourly wage to annual salary
Entre Nous,
You will have to make a few assumptions: 1. fulltime 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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How to enter a database function to average the annual salary?  Excel Worksheet Functions  
variable annual wage increases based on start date  Excel Worksheet Functions  
Excel converts formula to number  New Users to Excel  
salary, hourly wage plus commision  Charts and Charting in Excel  
How can I do an hourly salary calculation in Excel  Excel Discussion (Misc queries) 