Attached is an example how I would do this.


The worksheet Hidden is meant to be hidden. And columns colored yellow too. (On report sheets I did hide them, but on timetable sheet I left them visible currently.)


I assumed all registered time periods will be on same date. In case time periods do extend over midnight, you have to use datetime format instead of time format for TimeIn and TimeOut, to decide how you'll calculate date for entries, and to have the date calculated instead of to be entered (or to drop date column at all and to have month/year start and end dates taken into account when calculating TimeSpent for report sheets).

Attached Files

TimetableExample.xlsx (23.6 KB, 12 views)