HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 383
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Ingrebourne23.24.xlsx | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | H | M | N | O | P | Q | R | ||||||||||
1 | Day | Date | Start Time | Finish Time | Paid at Std Rate | Overtime Total | Bonus | Fuel Mileage | Daily Total | |||||||||||
2 | Days Hours | |||||||||||||||||||
3 | Monday | 29/01/2024 | 07:00 | 17:00 | 128.65 | 22.087 | 12.25 | 20.00 | 3.47 | 166.46 | ||||||||||
4 | Tuesday | 30/01/2024 | 07:00 | 17:00 | 128.65 | 22.087 | 12.25 | 20.00 | 3.47 | 166.46 | ||||||||||
5 | Wednesday | 31/01/2024 | 07:00 | 17:00 | 128.65 | 22.087 | 12.25 | 20.00 | 3.47 | 166.46 | ||||||||||
6 | Thursday | 01/02/2024 | 07:00 | 17:00 | 128.65 | 22.087 | 12.25 | 20.00 | 3.47 | 166.46 | ||||||||||
7 | Friday | 02/02/2024 | 07:00 | 17:00 | 128.65 | 22.087 | 12.25 | 20.00 | 3.47 | 166.46 | ||||||||||
8 | Saturday | 03/02/2024 | 00:00 | 00:00 | 0.00 | 0.000 | 0.00 | 0.00 | 0.00 | |||||||||||
9 | Sunday | 04/02/2024 | 00:00 | 00:00 | 0.00 | 0.000 | 0.00 | 0.00 | 0.00 | |||||||||||
10 | 643.25 | 110.44 | 61.25 | 17.35 | Gross Weekly Total | 832.29 | ||||||||||||||
11 | 15.5 | STANDARD | ||||||||||||||||||
12 | 23.25 | O/Time | ||||||||||||||||||
13 | 1.4 | Bonus | ||||||||||||||||||
14 | 0.1735 | Fuel | ||||||||||||||||||
290124 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
M3:M9 | M3 | =(J3*24)*A$12 |
N3:N9 | N3 | =(F3*24)*A$13 |
M10:N10,R10,P10,H10 | M10 | =SUM(M3:M9) |
B4:B9 | B4 | =B3+1 |
H3:H9 | H3 | =(E3*24)*A$11 |
P3:P9 | P3 | =O3*A$14 |
R3:R9 | R3 | =H3+M3+N3+P3 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
C3:D9 | Cell Value | >0 | text | NO |
This is my attempt at a weekly timesheet... the totals are right but it has need of an expert eye because its rough.
The pay is worked on a basic 39 hrs week 8hrs mon to thurs 7 hrs friday breaks of 45min are unpaid 30mins per day for paperwork added to the 39 basic giving 41.50hrs paid at base rate hours above this paid at 1.5x
Then to complicate things further a bonus of 1.40 paid for the hours worked less breaks and 30mins paperwork time so in the example sheet 8.75hrs per day for bonus.
Hope this makes sence im sure it can be made a lot better but not with macro's as i want to run it on my android phone to keep track of things. any help would be fantastic.