Need help Select Query to identify work hours per day


I need support for a MySQL Select Creation Query for the working hours. I have a sql table with Start and End working time. Both in DateTime format. This working time must be classified for four column such regular work, overtime and so on. I created a description for seeked columns and conditions. Please have look and let me know if you can solve it

Attached is sql-table and the same table as csv table and a ducument that describe the case.

Please keep in mind that I need a SELECT Query to create a View.

Skills: MySQL, PHP, SQL, Database Programming

About the Client:
( 22 reviews ) Zürich, Switzerland

Project ID: #34806754

Awarded to:


Hi, I am HR attendance Software expert (You can see my profile) ... I mostly work for this time attendance, Total work time , Overtime , Late calculation by create query ... this is easy for me which you have attached More

$25 USD in 1 day
(48 Reviews)

9 freelancers are bidding on average $33 for this job


Hi, Hope you are doing well. I'm a senior developer with 9 years of experience in Database Programming, PHP, SQL and MySQL. It sounds interesting in your project. please contact me and let's discuss more in detail. For More

$30 USD in 1 day
(78 Reviews)

HI! I am an expert web programmer. I am familiar with Laravel and I have a lot of work experience in Laravel, Codeigniter, PHP, Wordpress, JavaScript, HTML, Vuejs, Reactjs, React Native, and MySQL. I can start right aw More

$30 USD in 1 day
(99 Reviews)

Hi, How are you? I've just checked the attachment. Upon reading brief details I believe it's a doable job I have great experience doing projects with PHP, SQL, Database Programming and MySQL. I am confident about gett More

$10 USD in 1 day
(92 Reviews)

Hi i am sql expert and i am ready to work of you hour base message me thanks

$20 USD in 7 days
(21 Reviews)

Hi, there. How's it going? This is Tyler, high-level web developer I am perfectly confident that I can meet your requirements with high quality and fast processing. It promises free updating and fixing, high performan More

$30 USD in 1 day
(1 Review)

hello dear customer, i've read your project.I have several years of experience in sql and solving complex queries. I'm shure i can help you with your tasks. I already had similar projects, where i had to evaluate boo More

$100 USD in 1 day
(4 Reviews)

~1HOUR NO PROBLEM~ Hello. I read your description and check the attached PDF file and understood your requirements very clearly. As a PRO PHP/Mysql expert that kind of problem is a cake for me. I'm ready to start your More

$25 USD in 1 day
(2 Reviews)

I have gone through your project description and am looking to provide my service for the project. Please send a message so we can communicate further about the project. Completed Project: 3000+ as a freelancer on Di More

$30 USD in 1 day
(0 Reviews)