Do some Excel Work

I need the coding in order to quickly outline the following:

1. total hours/mins per week and also per fortnight

2. overtime hours/mins of anything over 9 hrs per day (part-timers only)

3. overtime hours/mins of over 5 hours worked without a break (casual & part time)

4. overtime hours/mins

5. Saturdays highlighted in yellow and Sundays highlighted in Green

I also need a quick way of deleting columns that I do not need. In this example, I do not need columns H-K; P-W; Y-AD.

Sheet1 is how the data is exported initially. Spreadsheet ppe [url removed, login to view] is how I edit it to include all the info I need, but it takes a while. Also the times are in decimals but I use a calculator to find out the minutes. I need the code to find the above values and convert them from decimals to hrs and mins.

Evner: Dataindførsel, Databehandling, Excel

Se mere: work values, sundays, excel w, excel calculator, Do some excel work 2, do some excel work -- 2, convert calculator, convert excel calculator, convert code excel, work hours spreadsheet, excel spreadsheet hours worked, excel edit, coding excel, data edit excel, overtime calculator, excel coding, edit part time, EDIT EXCEL, need order excel work, excel work order, work order excel, data entry coding excel, data coding excel, calculator excel, hours work per day hours week

Om arbejdsgiveren:
( 0 bedømmelser ) Australia

Projekt ID: #6023385

22 freelancere byder i gennemsnit $48 på dette job


Dear Sir/Madam, I'm happy to help you on this task and I can do this perfectly within few hours (Max 3), You can visit my profile to see my qualifications, experience and ratings, and if you are comfortable, I am read Flere

$50 AUD in 3 dage
(106 bedømmelser)

Hi, I'll be happy to help you with this project Please feel free to message me if you need to discuss any questions you might have prior to award

$50 AUD på 1 dag
(86 bedømmelser)

I am an Excel expert. Please take a look at my reviews for Excel projects and consider me positively.

$55 AUD in 2 dage
(132 bedømmelser)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

$70 AUD in 5 dage
(91 bedømmelser)

I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to identify the current input and ou Flere

$55 AUD in 2 dage
(53 bedømmelser)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Flere

$76 AUD på 1 dag
(46 bedømmelser)

Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful

$30 AUD på 1 dag
(43 bedømmelser)

Hi , I can help with your assignment. I have closed more than 150 excel projects. Please provide the excel sheet for having a better understanding of work. Regards Sawan

$34 AUD på 1 dag
(9 bedømmelser)

Hi: I have done multiple macro projects. Please check my profile to confirm. I would be happy to discuss your requirements in details. Please connect with me.

$35 AUD in 3 dage
(16 bedømmelser)

Hi I am an excel-vba expert and I can help U with your project pm me ..........................................................................

$166 AUD in 3 dage
(17 bedømmelser)

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [login to view URL] Estate (video demonstration) [login to view URL] (video demonstrat Flere

$69 AUD in 3 dage
(23 bedømmelser)

Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom

$66 AUD in 2 dage
(11 bedømmelser)

Hello! I interested in this project. I worked as an analyst in several retail companies for over 10 years and I have extensive experience in software development and automation using Excel, including VBA Coding, Macro Flere

$40 AUD in 3 dage
(1 bedømmelse)

Dear Sir, I've checked your attached files and your requirements. I have experience in Excel and completed excel projects here on I can start your project immediately. Please contact me to discuss Flere

$40 AUD in 2 dage
(1 bedømmelse)

Hi Expert Excel user here. Send me the material and I'll start at once working on it. I think I can send you something this evening or tomorrow morning, depending on how much material it is. Waiting for Flere

$25 AUD in 3 dage
(1 bedømmelse)

Hi . I have already finished your project out of interest. It is a very simple program. If you want, I can mail it to you independently on goodwill. You can review it and let me know if it works for you and award me Flere

$15 AUD på 1 dag
(1 bedømmelse)

Hi, I am Perl Expert. Using Perl Script i can play with Excel, I ll give you a Tool and you give the path of your Excel Sheet. Its Enough My tool will generate another Excel as per your Expectation. Just Google Flere

$20 AUD på 1 dag
(1 bedømmelse)

Hi, As I see in job description and excel files, you need to do the following things; -Copy selective data from sheet 1 and copy to another sheet -Organize and format data. -Calculate hours/ day and week and ove Flere

$35 AUD in 2 dage
(0 bedømmelser)

A proposal has not yet been provided

$24 AUD på 1 dag
(0 bedømmelser)

Hi, I've a good experience of automation using excel macros(I've been doing this for past 3-4 years now). The work you mentioned (assuming that is no changes to the required functionality) is not more than few hours Flere

$25 AUD in 2 dage
(0 bedømmelser)