Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula that can take a number (18) and know that it has to take the first 8 our of that 18 and multiply the straight time rate, the next 4 our of the 18 and multiply by overtime, and the next 6 out of that 18 and multiply by the double time rate.
The hours will not always be 18 hours but that is gonna be the max hours. Sometimes it might only be 8 hours or 12 hours. However, i need it to sum up the total hours (8,4,6) and know what rates to multiply them by.
Solved by C. E. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/02/2018 - 01:54
Welcome to GotitPro!
Excelchat Expert
03/02/2018 - 01:57
I understand that you want to calculate amount for 3 different shifts.
User
03/02/2018 - 02:01
Apoligies, i made a mistake. It is anything past 10 hours, needs to be miltiplied by the OT rate.
Excelchat Expert
03/02/2018 - 02:02
OK, No problem.
Excelchat Expert
03/02/2018 - 02:02
I am working on it, please be with me.
User
03/02/2018 - 02:03
Thank you very much
Excelchat Expert
03/02/2018 - 02:05
Please check E2 for solution.
Excelchat Expert
03/02/2018 - 02:08
Are you there ?
User
03/02/2018 - 02:09
Yes! Thats great thank you so much!
Excelchat Expert
03/02/2018 - 02:09
Thank you for visiting us!
User
03/02/2018 - 02:09
What if i have more questions. Is there a paid way to go about this type of help
User
03/02/2018 - 02:09
Or is it always 20 minutes free sessions?
Excelchat Expert
03/02/2018 - 02:10
Yes, if you have more question you can re-post.
Excelchat Expert
03/02/2018 - 02:10
First session is free.
User
03/02/2018 - 02:10
Okay awesome thank you. I will review the site for getting more details
Excelchat Expert
03/02/2018 - 02:11
Please leave your valuable feedback.
User
03/02/2018 - 02:11
Okay, i have another question since i get a free extension.
User
03/02/2018 - 02:12
Standby please, i am going to get into a little more details with this same topic
Excelchat Expert
03/02/2018 - 02:12
Sorry, it is company policy for single question per session.
Excelchat Expert
03/02/2018 - 02:12
If you have additional question please re-post.
Excelchat Expert
03/02/2018 - 02:12
1 session (16 credits) for $3.99
Excelchat Expert
03/02/2018 - 02:13
3 sessions (48 credits) for $9.99
User
03/02/2018 - 02:13
My session shows 20 minutes left
User
03/02/2018 - 02:13
It said 1 free extension during beta period and i seleceted yes
Excelchat Expert
03/02/2018 - 02:14
No, it is 20 mins and extension is only if your original question not solved.
User
03/02/2018 - 02:14
Ohhhh i understand. Its the same formula, i just need to add a little to it because i did not explain myself the right way.
User
03/02/2018 - 02:15
Its okay if not.
Excelchat Expert
03/02/2018 - 02:16
Sessions are audited regularly, we have to stick to our company police otherwise termination of our contract is possible.
User
03/02/2018 - 02:17
Okay, can i just pay so we stay in this session?
Excelchat Expert
03/02/2018 - 02:17
You can re-post with the same file.
User
03/02/2018 - 02:18
Okay, how do i save what we have here already?
Excelchat Expert
03/02/2018 - 02:18
Go to File -> save as xlsx.
Excelchat Expert
03/02/2018 - 02:18
Sorry "Download as".
User
03/02/2018 - 02:18
Okay got it! Thank you!
Excelchat Expert
03/02/2018 - 02:19
It is my pleasure to help you!
Excelchat Expert
03/02/2018 - 02:19
Please leave your valuable feedback.
User
03/02/2018 - 02:19
Yes of course
Excelchat Expert
03/02/2018 - 02:20
You can close session then repost.
Excelchat Expert
03/02/2018 - 02:20
Have a good day!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
