In case you are evaluating work hours without including break timings then this article is for you. In this article, we will calculate work hours based on their start & end time with a specific condition i.e. if the working hours are less than 8:30 or 8.5 hours then formula should do nothing else formula should deduct 30 minutes.
Question: I need this formula to work over the number of hours worked multiplied by number of workers, and it must be minus 30minutes off if they have worked over 8.5 hours. If they have worked for less than 8.5 hours then result should be produced in form of exact working time of the workers.
Following is the snapshot of data we have:
Conclusion: If you have also have prerequisite condition with very few changes then this tutorial will definitely help you & we can evaluate working hours after subtracting break timings.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
What a wonderful helpful tip, adding to my knowledge as well.
useful.