» Creating a Timesheet
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Creating a timesheet which calculates the number of hours worked each day and a sum of the total hours worked.
Solution:
Create 3 columns containing the following data:
Date (column A), Time In (column B), Time Out (column C).
In the 4th column (Number of Hours), enter the following formula:
=(C2-B2+(C2
=SUM(D2:D7)
Book Store:
Sunday/Saturday Null
Judy
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
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
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
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.
Break deductions
Mark
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
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
Re: Creating a Timesheet
black.panther
How do you create a timesheet to where it counts 12 am?
For example if you work form 5 pm till 12 am
here is another example work form 4 pm till 2 am
See I have a formula that does the figuring for time worked with breaks counted for but cannot figure out how to make it count for the midnight or morning hours. For people that works the night shift real late night shifts.
Re: Creating a Timesheet
shg
This is not a question forum. Please take a few minutes to read the forum rules.
