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...
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.