Need help Select Query to identify work hours per day

$10-30 USD

Completed

Posted

over 1 year ago

$10-30 USD

Paid on delivery

Hi, 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.

Project ID: 34806754

About the project

9 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@tutulsoft

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 all documents and sql scripts . yes, i can create a query which solve you 100% as you required

$25 USD in 1 day

4.9

(48 reviews)

6.0

9 freelancers are bidding on average $33 USD for this job

@rukshanlancer

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 details Chat with me.

$30 USD in 1 day

4.9

(78 reviews)

7.1

@kamransiyal9

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 away. I want to discuss this project in detail. Please contact me to discuss more regarding this project. For more details Chat with me

$30 USD in 1 day

5.0

(99 reviews)

6.4

@muhammasahmed

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 getting this done. While I believe we need to have a detailed discussion about it. I work as per Eastern time daily so that would be good for us to catch up on this job, Let's discuss this further and get started for you as soon as possible. Thanks! Muhammad

$10 USD in 1 day

5.0

(92 reviews)

6.1

@freelancersandh1

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

$20 USD in 7 days

5.0

(21 reviews)

5.1

@tyleleerking

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 performance, excellent UI, and always-on communication without bugs. Call us anytime to click chat. Kind Regards, Tyler

$30 USD in 1 day

5.0

(1 review)

3.2

@kattymokh

~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 project and I can finish it with high quality and clean code. Thanks for your consideration. Best Regards

$25 USD in 1 day

5.0

(2 reviews)

1.6

@ARKSolution2015

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 Different platforms Education: Master in Software Engineering Experience in the Field: 7 years+

$30 USD in 1 day