| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i calculate what i make in a year into an hour?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
| how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
| Calculate rate per hour | Excel Discussion (Misc queries) | |||
| Calculate hour and minutes worked each day | New Users to Excel | |||
| Calculate time difference to the half hour | Excel Worksheet Functions | |||
Linear Mode
