Hi,
I am having issues with a timesheet I use for work.
An excel forum member has helped me previously with a solution that is perfect.
Except, I would now like to add leave entitlements to the spreadsheet and have them automatically calculating like the rest of the sheet.
On the sheet, when I select start and finish times all the relevant hours are calculated and wage (rate) is updated with corresponding start time.
I would like to be able to select a leave entitlement from a drop down and then populate the cells relating to the hours received and wage owing.
Is there a way when a 'word' is selected instead of a start time that the sheet can populate the cells relating to how many hours the entitlement is worth
and how much wage is worth?
An example of what im trying to add is on the sheet.
Also Sundays are double time all day for all hours, but the sheet is taking into account time+half and double time hours when it doesn't need to.
Any help with this will be greatly appreciated,
Michael
Bookmarks