Hi.
I need some help please creating a time sheet to record hours and overtime calculations based on inputting staff start and finish times.
A1 = Name
B1 = Shift start (Can be anything between 00:01 and 23:59)
C1 = Shift finish (Shifts can start and finish on the same day, or start day one and finish day two)
Formulas required for the following...
D1 = Total hours worked for this shift
E1 = Hours worked between 0630-1830
F1 = Hours worked for this shift between 1830-0630
Many thanks.
Bookmarks