Danin
New Member
I need help simplifying an overly complicated timesheet. I am not the author of it, just a manipulator.
this workbook contains a payment summary sheet
a breakdown sheet for the payment that pulls daily dockets from
the third worksheet which is for docket entry from multiple areas by multiple people.
the fourth worksheet is all of the information that is sent to the daily docket worksheet.
My issue is I want to create less lines to be input on the daily docket register without causing issues or allowing me to compensate for the issues of me doing this.
I can get the daily normal/overtime/double time for day works formulas. i also managed to add a formula that states if more than 1 hour worked, daily fare is automatically added.
if more than 9.5 hours worked. meal allowance is added.
my problem lies in if they decide to do night work and also for the vehicle types.
Any help would be appreciated.
This register has been used on countless other areas and keeps getting used but no one has bothered to make it more streamlined. i would like to do this as it will be used over 3 year period.
this workbook contains a payment summary sheet
a breakdown sheet for the payment that pulls daily dockets from
the third worksheet which is for docket entry from multiple areas by multiple people.
the fourth worksheet is all of the information that is sent to the daily docket worksheet.
My issue is I want to create less lines to be input on the daily docket register without causing issues or allowing me to compensate for the issues of me doing this.
I can get the daily normal/overtime/double time for day works formulas. i also managed to add a formula that states if more than 1 hour worked, daily fare is automatically added.
if more than 9.5 hours worked. meal allowance is added.
my problem lies in if they decide to do night work and also for the vehicle types.
Any help would be appreciated.
This register has been used on countless other areas and keeps getting used but no one has bothered to make it more streamlined. i would like to do this as it will be used over 3 year period.