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

  • Thread starter Thread starter Guest
  • Start date Start date
Do you work 40 hours/week?
Do you work 52 weeks/year?

=YearlySalary/(52*40)




Gaby wrote:
 
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 <[email protected]> wrote:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate After hours 3
Vacation accrual based on years with rollover 1
SUMPRODUCT - Multiple Criteria 1
work hours with different hour prices 12
calculate hours 3
Scrabble Value calculation for Welsh words 0
Calculating Future Value 6
Calculate interest & withdrawals 0

Back
Top