Excel - SUM Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc