Timesheet Very Basic needs an expert eye

HappyChappy

Active Member
Joined
Jan 26, 2013
Messages
378
Office Version
  1. 2019
  2. 2010
  3. 2007
Platform
  1. Windows
Ingrebourne23.24.xlsx
ABCDHMNOPQR
1DayDateStart TimeFinish TimePaid at Std RateOvertime TotalBonusFuel MileageDaily Total
2Days Hours
3Monday29/01/202407:0017:00128.6522.08712.2520.003.47166.46
4Tuesday30/01/202407:0017:00128.6522.08712.2520.003.47166.46
5Wednesday31/01/202407:0017:00128.6522.08712.2520.003.47166.46
6Thursday01/02/202407:0017:00128.6522.08712.2520.003.47166.46
7Friday02/02/202407:0017:00128.6522.08712.2520.003.47166.46
8Saturday03/02/202400:0000:000.000.0000.000.000.00
9Sunday04/02/202400:0000:000.000.0000.000.000.00
10643.25110.4461.2517.35Gross Weekly Total832.29
1115.5STANDARD
1223.25O/Time
131.4Bonus
140.1735Fuel
290124
Cell Formulas
RangeFormula
M3:M9M3=(J3*24)*A$12
N3:N9N3=(F3*24)*A$13
M10:N10,R10,P10,H10M10=SUM(M3:M9)
B4:B9B4=B3+1
H3:H9H3=(E3*24)*A$11
P3:P9P3=O3*A$14
R3:R9R3=H3+M3+N3+P3
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C3:D9Cell Value>0textNO


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.
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand
The formulas I have used are jury rigged and will not stand up to various time inputs as the calculations are beyond my skill set needs a guru's eye to work it out.
 
Upvote 0

Forum statistics

Threads
1,215,097
Messages
6,123,076
Members
449,094
Latest member
mystic19

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top