You may need to install the Analysis Toolpack/VBA, click Tools - Add-ins, tick them and then click OK
Enter Target Hours and then enter start and finish timse for each day including lunch times.The Hours Worked column shows how many hours have been worked in the day and Hours Remaining shows how many hours are left to work. The second table will let you calculate your monthly hours. Enter the Target Monthly Hours and the number of weeks in the month. Add the daily hours for each weekday and the Weekly To Work & Weekly Overtime columns will automatically calculate.