ExcelBanter - how do i calculate what i make in a year into an hour?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how do i calculate what i make in a year into an hour? (https://www.excelbanter.com/excel-worksheet-functions/146417-how-do-i-calculate-what-i-make-year-into-hour.html)

Gaby

how do i calculate what i make in a year into an hour?

MH[_2_]

how do i calculate what i make in a year into an hour?

How many hours do you work each year?

MH

"Gaby" wrote in message
...

Dave Peterson

how do i calculate what i make in a year into an hour?

Do you work 40 hours/week?
Do you work 52 weeks/year?

=YearlySalary/(52*40)

Gaby wrote:

--

Dave Peterson

Gord Dibben

how do i calculate what i make in a year into an hour?

In A1 you have your annual salary..............87,000

In B1 you have the number of hours worked in the year.

In C1 enter =A1/B1

OR more simply in any cell enter =salary/hours

Gord Dibben MS Excel MVP

On Wed, 13 Jun 2007 14:38:02 -0700, Gaby wrote:

All times are GMT +1. The time now is 02:34 AM.