The purpose of the Employee Schedule spreadsheet is to create and build a schedule to coordinate several employees start/end times and lunches. The fixed lunch time reduces the flexibility of this spreadsheet as a time recording tool.
The tool that I believe Corrinna and I would like is spreadsheet to enter start/end times for a given day worked into a spreadsheet that calculates the duration of hours worked, at lunch, and overtime worked (daily, weekly/pay period).
I played with the equations and the duration crossing the 12-o-clock did not output the correct duration. Note the value in Hours (Combo Fx) cell.
Date |
In |
Out (Lunch) |
In (Lunch) |
Out (Lunch) |
Hours (Morning) |
Hours (Lunch) |
Hours (Afternoon) |
Hours (Combo Fx) |
Overtime |
6/4/18 |
7:00 |
11:00 |
11:30 |
16:30 |
4:00 |
0:30 |
-31651:00 |
-31647h 0m |
|
6/5/18 |
7:00 |
10:15 |
11:15 |
17:30 |
3:15 |
1:00 |
-31649:45 |
|
|
Hours (Combo Fx)
(IF(OR(ISBLANK($In '6/4/18'),ISBLANK($C2)),DURATION(0), $C2−$In '6/4/18'))+(IF(OR(ISBLANK($'In (Lunch)' '6/4/18'),ISBLANK($E2)),DURATION(0), $E2−$'In (Lunch)' '6/4/18'))
I re-entered the end time and the output corrected, which was not intuitive.
Date |
In (begin) |
Out (Lunch) |
In (Lunch) |
Out (end) |
Hours (Morning) |
Hours (Lunch) |
Hours (Afternoon) |
Hours (Combo Fx) |
Overtime |
6/4/18 |
7:00 |
11:00 |
11:30 |
16:30 |
4:00 |
0:30 |
5:00 |
9h 0m |
|
6/5/18 |
7:00 |
10:15 |
11:15 |
18:45 |
3:15 |
1:00 |
7:30 |
10h 45m |
|
6/6/18 |
6:45 |
11:15 |
11:45 |
18:30 |
4:30 |
0:30 |
6:45 |
11h 15m |
|
Now I need to summarize the results to show anything over 8 hours at overtime, such as a table with duration of regular hours, lunch, and overtime. Recommendations are welcome.
I'm still wondering where the time entry log template is in Numbers.
