Timesheet
Also known as · Time Sheet
A monthly attendance sheet that turns start and stop times into regular hours, overtime and pay. The user types only the month and year, and the dates, hours and salary come from formulas.
When to use
It combines the Lec 05 ideas: dates built with DATE and +1, hours as (Stop-Start)*24, an IF Function splitting regular hours (up to 8) from overtime, and Sheet Protection leaving only the inputs unlocked. In the class example, total salary was NIS 419.33.
See Lec 05.