| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If then statement
Work sheet 1 is an overtime sheet for a dept. I have a cell with employees
names in it and next to that is the hours working. On sheet two I want to add all (if more then one shift) hours for each individual employee for the entire weekend. Sheet 1 6am-12.00pm 8 bill 0.00-8.00am 8 Nancy I want to add mark hours on 0.00-8.00am 5 mark sheet 2 8.00am-4.00pm 7 Doug mark 13 8.00am-4.00pm 8 mark Nancy 8 8.00am-4.00pm 5 Tim Tim 5 Bill 8 Doug 7 Can you give me a formula please! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| Using an IF statement, or VLOOKUP statement | Excel Programming | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
Linear Mode
