Forum Discussion
Calculating an hourly penalty rate within a shift that may have non-penalty hours within that shift.
In the attached version, I have cleared the start and end times for day you don't work,
Instead of first calculating the penalty hours, I have first calculated the normal hours, then calculated penalty hours as total - normal.
Could you attach a sample workbook without sensitive information, or make it available through OneDrive, Google Drive, Dropbox or similar?
Hi Hans,
Please find attached the workbook I have been working on.
I hope you have received my previous post re the reason for my inquiry.
Also note I am using an old laptop with an old version of excel.
I have a number of issues to resolve,
1. I am trying to calculate a penalty rate. A friend has tried to help but we are having problems as you can see.
For example if I am not working on that day then I still have a default of 4 hrs is calculated, and we cannot calculate the 2nd. half.
2. Another issue is I have to build a VLOOKUP so that when I enter in a Work Status (Column C and Drop Down List sheet)) information is calculated by the specific cell. For example if I have annual leave the default time of 8 hrs will show in column AA. Conversely if I am sick it will show in AB.
Anyway step-by-step. Right now I need to resolve the penalty rate issue.
Once again thank you ... Cheers Michael
In the attached version, I have cleared the start and end times for day you don't work,
Instead of first calculating the penalty hours, I have first calculated the normal hours, then calculated penalty hours as total - normal.
- hans Vogelar
Thank you sooooo much.
I can now push ahead with what I am capable of.
Is it possible to seek your assistance further if so required?
My next phase is putting together VLOOKUP table so when I enter in the work status drop down entry the start time will recognise it to be zero where applicable.
For example if I have Annual Leave as the work status then column AA will show the desired hours, in this case 8. Conversely for sick day, and so on.
I do hope I am not adversly drawing on your 'intellectual property' ... hahha.
As a side note from a excel professional, do you think the way I am setting it out looks easy to read and interpret?
Kind regards once again ... Michael
- Hi Hans,
I have no problem sending you the file, thank you for your kind assistance.
I have a Google Drive account.
As a background for you I am a bus driver in Sydney, Australia. Recently our company was taken over, and since then there has been issues with incorrect pay.
I am familiar with excel at a rudimentary level, and decided to try to build my own wages/pay calculator in order to verify if my pay is correct, before lodging a query with the accounts department.
This exercise is definitely challenging my abilities, and thus the reason for my post for help, but I am thoroughly enjoying learning excel at a new advanced level.
Please provide me your e-mail details so I can send the workbook to you.
Cheers Michael
