Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Used time for Payroll
I have a payroll sheet which consists of 14 days Sat-Fri and three
columns: DATE Date ET | USED | BAL | ET | Used | Bal | First some setup: ET (earned time) is populated only when the date cell is the first of the month, otherwise ET = 0 Used is only filled in when a person is using time Balance = Balance - used + ET If a person uses 8 hours of time in the 14 days, balance would be -8 in all 14 balance cells. Here's what's stumping me I have another sheet which displays Time used during the pay period. IF ET is populated on my spreadsheet I want to display the balance in the cell to the left for example: Date Date ET|USED|Bal | ET | USED | Bal -8 10 The formula would go into a cell and it would have to evaluate whether ET was < 0 and then if that was the case the cell would get populated with whatever was in the LEFT balance cell. I am totally stumped Thanks for your help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Used time for Payroll
Your requirement is not clear...
You need something like; IF(B2<0,C2,"") Where B2 is the cell you want to check for non-zero value. Replace C2 by the cell which contains the value you want to put if ET<0. You may send the file to me showing me what you want. "cmatera" wrote: I have a payroll sheet which consists of 14 days Sat-Fri and three columns: DATE Date ET | USED | BAL | ET | Used | Bal | First some setup: ET (earned time) is populated only when the date cell is the first of the month, otherwise ET = 0 Used is only filled in when a person is using time Balance = Balance - used + ET If a person uses 8 hours of time in the 14 days, balance would be -8 in all 14 balance cells. Here's what's stumping me I have another sheet which displays Time used during the pay period. IF ET is populated on my spreadsheet I want to display the balance in the cell to the left for example: Date Date ET|USED|Bal | ET | USED | Bal -8 10 The formula would go into a cell and it would have to evaluate whether ET was < 0 and then if that was the case the cell would get populated with whatever was in the LEFT balance cell. I am totally stumped Thanks for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Payroll verification hrs and time off | Excel Worksheet Functions | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
what's the formular for time in payroll | Excel Discussion (Misc queries) | |||
Setting up scheduling and Time sheets for Payroll | Excel Worksheet Functions | |||
How do I set up payroll for 1 full time and 1 part time employee? | New Users to Excel |