View Single Post
 
Old 10-09-2019, 04:27 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 494
ArviLaanemets has a spectacular aura aboutArviLaanemets has a spectacular aura about
Default

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
File Type: xlsx TimetableExample.xlsx (23.6 KB, 4 views)
Reply With Quote