Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help to set up a spreadsheet
I am doing a spreadsheet for vacations. I will start with hours earned minus
hours used. Each pay period I need to add more hours earned to the last hours earned. Is there a way to do this without having to calculate each individual when the new hours earned is the same amount per employee? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help to set up a spreadsheet
You could put all the paydates across the top as column heading and the
people in rows, and then plug in the extra vacation they will earn for each month. You can then get the earned to date with a simple =SUMIF($1:$1,"<="&TODAY(),2:2)) which gives you the earned to date for the guy in row 2. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "vacation spreadsheet" <vacation wrote in message ... I am doing a spreadsheet for vacations. I will start with hours earned minus hours used. Each pay period I need to add more hours earned to the last hours earned. Is there a way to do this without having to calculate each individual when the new hours earned is the same amount per employee? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Big problem with excel recalculating spreadsheet | Excel Discussion (Misc queries) | |||
Linked Spreadsheet Opens | Excel Discussion (Misc queries) | |||
summarize data from one spreadsheet to other spreadsheet | Excel Worksheet Functions | |||
Working spreadsheet highlighting function for Excel 2007 | Excel Worksheet Functions | |||
Spreadsheet merging problems | Excel Worksheet Functions |