View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
zxc[_3_] zxc[_3_] is offline
external usenet poster
Posts: 1
Default 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
weeks in a year, if paid for full year.
"Entre Nous" Entre wrote in message
I need help creating a simple formula that converts an hourly wage to
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.