Lukket

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.

Færdigheder: 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 for dette job

priyal1997

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 Mere

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

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)
6.2
best4best

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)
5.9
dpune

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 Mere

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

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 Mere

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

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 Mere

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

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)
4.9
sawangupta

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)
4.5
aarifakhtar

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)
4.4
abdolah2014

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)
4.4
paris2785

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: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere

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

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)
4.1
ssviatlana

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 Mere

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

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

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

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 Mere

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

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 Mere

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

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 Mere

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

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 Mere

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

A proposal has not yet been provided

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

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 Mere

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