Creating an excel timesheet is easier with a template to start with. This blog post provides the template which includes lunch breaks and grand totals along with the instructions for using it.
Àll of the BLUE text above is data entry. So you need to enter all hours in the HH:MM format (short for Hour and Minute). The total hours column will calculate the hours considering a lunch break which will not be calculated. If the lunch is left out it only takes into account hours worked.
It is a straight forward template to manage and use and will give you a solid idea of hours worked.
Enjoy my version of this classic Excel problem.