Sunday/Saturday Null
Judy wrote on December 31, 1969 19:00 EST |
| I am making a time sheet and I need to have Sunday and Saturday be null (I would like it to be blacked out if there is a way) I cant have it just from Mon to Fri since our work schedule is from Mon to Mon. Also is there a way to black out given dates for holidays? |
Sunday/Saturday Null
Judy wrote on December 31, 1969 19:00 EST |
| I am making a time sheet and I need to have Sunday and Saturday be null (I would like it to be blacked out if there is a way) I cant have it just from Mon to Fri since our work schedule is from Mon to Mon. Also is there a way to black out given dates for holidays? |
lunch break
Judy wrote on December 31, 1969 19:00 EST |
| I need a time sheet sheet that will automatically deduct 1/2 hour if there is no entries in the lunch in/out columns.. |
Answers
Kathy wrote on December 31, 1969 19:00 EST |
For Null cells, just change the Fill color to black.
For missing lunch, use an IF statement.
For example, lunch out cell is C3, and time is totaled in D3.
=IF(C3=0,D3-30,D3)
Which says, if the lunch out cell is zero, take 30 away from the D3 total, otherwise leave the D3 total alone. |
Time Sheet - Regular & Overtime Formulas
jessi_780 wrote on November 20, 2006 16:01 EST |
| I am trying to create a spreadsheet and I need to total the hours worked. I also need to total the regular hours (up to 40 hours), and the over time hours (over 40 hours worked). Is this possible, and if it is how do I do it. Thanks so much for your help! ~ Jessica |
Break deductions
Mark wrote on December 31, 1969 19:00 EST |
Hi, i want excel to work out break deductions based on
1-4hrs worked 0 break
4-6hrs worked .25hrs break
6-11hrs works .45hrs break
11+ 1hrs break
any advice? |
incrementing the time
praveen wrote on December 31, 1969 19:00 EST |
Hi As soon as i enter the start time , it should update other rows by 10 minute and it should change the hour as soon as it reaches 60 minutes. Example 8:10,8:20
....8:60 then 9:10 like this....how can i do this please let me know. My email is pavi_sk@yahoo.com |
F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
