Forum Discussion
Time sheet for hours worked
I am needing to make a sheet that shows clocking in for work - clocking out for lunch - clocking in from lunch - clocking out for the day and then the total of those hours worked per day and then grand total for the week. For our pay system we do things in 6 minute increments. I found a sample sheet through Excel, but the formula we have still isnt just right. Here is what I have and the formula for the hours worked is what I am needing help on. Any help is very much appreciated!
2 Replies
It may be clear to you what "we do things in 6 minute increments" means in this context. I know what the phrase means--and am assuming it is convenient because it refers to tenths of an hour--but you don't make clear how you're using it (or hoping to use it) in tracking time. Here are the possibilities that occur to me. Does it mean you:
- round each entry to the nearest tenth of an hour
- round each segment of clocked in to clocked out to the nearest tenth of an hour
- only round the final total "Hours Worked" to the nearest tenth of an hour
- something else?
Sorry - wasn't sure how to word everything. So we round the total hours worked for each day to the nearest tenth of an hour. Here is an example -
Clocked in 8:00AM
Lunch out 12:00PM
Lunch in 1:21PM
Clocked out 5:00PM
Totals to 7.6
I am hoping there is a formula for excel that will give me that exact answer. Thank you :)
