Create a MYSQL View- Total Time Per Day

I have an existing MYSQL table called "time" which has sample timesheet entries from one week. See [login to view URL] for table and data.

The table has many fields, but only a few are needed to pivot for the view- hours, overtime, activity, notes, date_2, wo_number, utility_charge. See ExistingTable.PNG.

I need the view to look like MysqlPivot.PNG.

Each record should be listed separately, but the time as entered into "hours", along as to if it is overtime or not (R is Regular time, O is Overtime) should be in the correct day of the week in the view. Also the total hours for each record should display.

As an example, the first record should look like [login to view URL]


Evner: Database Administration, Programmering af database, MySQL, SQL

Se mere: create mysql database iis, php mysql insert date time, create mysql database phpmyadmin, create view mysql workbench, how to calculate total hours in mysql, create view in mysql w3schools, mysql create view from multiple tables, how to calculate total working hours in mysql, create view in mysql with join, mysql create view example, php mysql daily sales report, part time per hour, media player total time, create mysql table form data, phpfilenavigator create mysql database, create mysql email database, create mysql dbase remote, create gmail account 1000 creation per day, mysql display page time view, view real time data php ajax mysql

Om arbejdsgiveren:
( 7 bedømmelser ) Portland, United States

Projekt ID: #19809848

Tildelt til:


Hi, I have checked the table and images. I would like to pivot the data over weeks. Available for discussion and ready to start now. Regards, Manish

$30 USD på 1 dag
(84 bedømmelser)

9 freelancere byder i gennemsnit $34 på dette job


I read your requirements and make changes according to you. I have 8+ years of experience. I assure you that i will give 100% quality work. Let us discuss and proceed further in chat. I am online. Please reply.

$50 USD in 3 dage
(11 bedømmelser)

hello, i understand your requirements... please contact me or accept my bid so that we can discuss more and start soon... i m expert in this type of project. u can also see my portfolio... please, give me a chance to f Flere

$50 USD in 7 dage
(18 bedømmelser)

Hello. I looked carefully at your posts. database manage & programming is my best work. also i have a enough history in this part. If you have the opportunity to talk to me, I think I can create a less cost effecti Flere

$30 USD in 0 dage
(8 bedømmelser)

Interesting Wonderful project! We are good team in many experiences in Web developing. We are masters of math and web design. If you keep in touch with us, you can get satisfy result. Thanks a lot!

$20 USD in 7 dage
(1 bedømmelse)

Hi, there. I've read all of your requirements extremely carefully. This is the one of a team experienced in PHP, MySQL and Javascript. It will be pleasure to work with this project. I'd like to discuss in detail over c Flere

$25 USD på 1 dag
(1 bedømmelse)

Hi. I've read your project description, so that I think I can help you perfectly. I've strong experience in Web Design & Developing, and I do look forward to discuss any details over chat. I promise, I'll do my best Flere

$25 USD på 1 dag
(0 bedømmelser)

Hello, I am new to here this platform freelancer.com but developed number of websites with database mysql and mobile apps in last 9 years. I can Create a MYSQL View- Total Time Per Day as per your mentioned bri Flere

$40 USD in 2 dage
(0 bedømmelser)

i can do everything for you as i am very needy for money as my family is suffering from money sacrifices

$35 USD in 7 dage
(0 bedømmelser)