Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Time Sheet Reads as followed:
A B C D E 4 Mark 8.00 4 5 Joe 12.00 0 6 Jim 5.00 5 7 Jay 6.00 0 8 Julie 7.00 5 9 Zoe 6.00 0 10 Al 5.00 6 11 Ken 5.00 0 A= Employee's B= Hourly Rate C,D,E,etc. = Weekday hours How do I create a formula to figure The Employee Number Daily for column C? I have 8 employees total, but only 4 employees worked that day. I need a formula give me the total for Column C of my 8 employees only 4 worked in Column C that day. The answer is 4 -- Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate the time an employee signed in and out plus rate per hr | Excel Discussion (Misc queries) | |||
Fromula to take employee # out of employee name field | Excel Discussion (Misc queries) | |||
subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions | |||
Referencing a newly created worksheet | Excel Worksheet Functions |