Thread
:
What Excel formula converts hourly wage to annual salary
View Single Post
#
6
Posted to microsoft.public.excel.newusers
zxc[_3_]
external usenet poster
Posts: 1
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
Reply With Quote
zxc[_3_]
View Public Profile
Find all posts by zxc[_3_]