Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
What Excel formula converts hourly wage to annual salary
3,312 views
Skip to first unread message
Nous@discussions.microsoft.com Entre Nous
Jun 1, 2010, 4:24:05 PM6/1/10
to
I need help creating a simple formula that converts an hourly wage to an
annual salary.
annual salary.
Max
Jun 1, 2010, 4:44:01 PM6/1/10
to
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
---
calculate it by hand? Explain it fully, step by step. This increases your
chances of getting help with the formula.
--
Max
Singapore
---
John
Jun 1, 2010, 6:14:56 PM6/1/10
to
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 No...@discussions.microsoft.com> wrote in message
news:93A0F53E-529C-4622...@microsoft.com...
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 No...@discussions.microsoft.com> wrote in message
news:93A0F53E-529C-4622...@microsoft.com...
Gordon
Jun 1, 2010, 5:43:20 PM6/1/10
to
"Entre Nous" <Entre No...@discussions.microsoft.com> wrote in message
news:93A0F53E-529C-4622...@microsoft.com...
> I need help creating a simple formula that converts an hourly wage to an
> annual salary.
> annual salary.
You need to calculate the number of hours worked in a year and then multiply
that by the hourly rate.
zxc
Jun 2, 2010, 10:27:19 AM6/2/10
to
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 No...@discussions.microsoft.com wrote in message
> I need help creating a simple formula that converts an hourly wage to
> an
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
FloMM2
Jun 4, 2010, 12:03:44 PM6/4/10
to
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
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
0 new messages