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 gra...
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?
You can just calculate morning time plus afternoon time, then round it. For example, total hours = (lunch out − clock in) + (clock out − lunch in). Then round that result to 6-minute increments using MROUND. After that, sum your daily totals for the week. Make sure the cells are formatted as time so it calculates correctly. This setup usually works for simple timesheets.