Excel Overtime Entry Automation

I maintain a master workbook that already holds every staff member’s name, code and job title. What I need is an additional ­sheet­—or a companion file—that lets me record overtime quickly while pulling those personal details automatically, so no one has to re-type them. Here is the workflow I have in mind: • I type (or select) the staff code and the date; Excel instantly fills in the person’s name and job title from the master list. • I enter the start and end time; the sheet calculates total hours worked as well as total overtime hours. • All formulas run in the background so the only fields we touch are staff code, date, start time and end time. • A running log grows day by day, and at the click of a button I can produce a clean monthly report that summarises overtime per employee. I am fine with VBA, Power Query or structured formulas—whatever achieves a smooth, error-free experience for my team and keeps everything inside Excel. The finished file must be easy to reset for the next month while archiving prior data.

Project ID: 40393534