| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time sheet
I have this formula and I would like to add a little bit more to the theory
In the time sheet is has done everything i asked minus meal breaks etc. But I am looking for if the staff member goes from the work place they are classed as off line I need for the time sheet to automatically place 7 hours in cell g6 if the word "off line" is written in cell g5 Thanks in advance Greg |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time sheet
This is one way =IF(G5="Off Line",7,"") place this formula in cell G6.
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Time sheet
Thankyou, still trying to learn the language
Greg "trussman" wrote in message oups.com... This is one way =IF(G5="Off Line",7,"") place this formula in cell G6. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet - Calculating Time Differences for Totals | Excel Discussion (Misc queries) | |||
| Annual Wages Sheet to pick up info from Time Sheet | Excel Worksheet Functions | |||
| Detailed Time Sheet (overtime, comp time, vacation used) | New Users to Excel | |||
| How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
| I need a time sheet template that verifies time entered against sy | Excel Discussion (Misc queries) | |||
Linear Mode
