Hi, been on this for a few days with no avail. Pretty new to spreadsheets and wanted to create one that calculated my pay from the exact minute to the exact dollar. Not to sure how it would work, as I haven't had much luck running it through AI.
If anyone could give me a hand or an explanation, or just tell me I'm too optimistic, that would be greatly appreciated.
All rates are on the sheet, with an example time and simple spreadsheet layout.
Cheers
Pay Advice.xlsx
Welcome to the forum.
There is no Excel 2024 ... yet.
Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.
The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.
Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Apologies, I am using MS365 Version 2401
This proposal employs a lot of helper columns and adds some rows to the top of the sheet.
A list of holidays will need to be added to the sheet and the formula modified to finalize the spreadsheet.
Note that the added rows and helper columns may be hidden for aesthetic purposes.
The formula used to calculate time worked is:Formula:
Please Login or Register to view this content.
The formula used to calculate break time is:Formula:Please Login or Register to view this content.
The final output in column G is populated using:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Only just got to this now. THANK YOU HEAPS! Does exactly the job i was hoping for
If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
You're Welcome and thank you for the feedback. As AliGW stated, please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks