Question description:
This user has given permission to use the problem statement for this
blog.
i need a formula that calculates the hours in column a, b, c, d, e, f, g and puts the sum in column h bu the maximum can only be 44 hours, anything over 44 hours needs to go in column i.
Solved by A. A. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
11/07/2018 - 05:15
payroll
Excelchat Expert
11/07/2018 - 05:16
Hello, I understand that you need help with summing several columns but have a hard cap and anything in excess gets moved to the next column, right?
User
11/07/2018 - 05:16
yes
Excelchat Expert
11/07/2018 - 05:17
Alright, I can help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
Excelchat Expert
11/07/2018 - 05:17
Are you able to share a sample so I can analyze it and offer the best possible solution?
Excelchat Expert
11/07/2018 - 05:19
Ahh, thank you. Now it makes more sense when you put it like that. :)
Excelchat Expert
11/07/2018 - 05:19
So you are calculating the regular and overtime hours.
User
11/07/2018 - 05:20
i need the formula to cap it at 44 hours in column h and the excess hours go to column i
Excelchat Expert
11/07/2018 - 05:20
Alright, please check the formula in H and I and help me out by testing it.
Excelchat Expert
11/07/2018 - 05:22
Are you still with me?
User
11/07/2018 - 05:22
yes, testing it
Excelchat Expert
11/07/2018 - 05:23
Oh okay.
User
11/07/2018 - 05:24
it works, thank you :)
Excelchat Expert
11/07/2018 - 05:24
You are welcome!
Excelchat Expert
11/07/2018 - 05:24
Glad to have helped!
Excelchat Expert
11/07/2018 - 05:24
Would there be anything else that I can help you with regards to the original question?
User
11/07/2018 - 05:25
that is it,
Excelchat Expert
11/07/2018 - 05:25
Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert
11/07/2018 - 05:25
I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.
Excelchat Expert
11/07/2018 - 05:25
Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
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.
