Converting leave (date and time) information to calendar form
$250-750 USD
Completed
Posted over 10 years ago
$250-750 USD
Paid on delivery
I need a code to automatically post information from the leave summary to the leave calendar.
Information from Column B, C, H, I and K from the individual summary need to be transferred to the leave calendar. Please take a moment to view them the summary and calendar as it is complicated to describe it all.
Column B and C is the first and last name for the individual.
Column H and I is for the date(s) the leave is taken, and is needed to plot the exact coordinates on the leave calendar.
Finally, Column K is the total number of hours which applies to annual leave only.
7.5 hours is the maximum for one day. Always use 7.5 hours for the first day, and let the remainder be distributed to the following days. For example, if an 11.5 hour annual leave is taken for 2 days, put 7.5 in the first block and 4 hours in the second block, and color the first light blue and the second brown (for any value under 7.5). Please see the legend for the correct colors.
For the rest of the leave type, color the box with the correct color but leave the value blank.
Please also provide instructions how to use this code for individual summary that is generated in the future.
Serious bidders only, thank you!
Hello, Thank you for the opportunity to assist you in converting leave information to calender form.
I have been working on these types of projects for over 11 years.
Now I am into home based freelancing and hence available to help you.
Excellent computer skills and attention to detail are my strong points.
I look forward to hearing you.
Thank you
Sincerely
Malini
$250 USD in 3 days
4.9 (16 reviews)
3.6
3.6
10 freelancers are bidding on average $445 USD for this job
I am expert in data processing, analysis and entry.
Your task seems to be done with higher attention and I hope to do it in least that I am expert in excel, word and Google docs.
Feel free and contact back through freelancer Your task will be done in least time.
Have a nice time...
i am a part of HR person in my current company and also responsible for the attendance and leave for all staffs. i also using the excel to make all staff attendance for quick review. and easy to track.
hoping that you may hire for the task and if soyou may contact me anytime. thanks.
Hi there,
I have gone through your sheets and project summary. We can help you in doing this project with the needed requirements. I have some questions to you, kindly come in contact here, we can discuss and start the process.
Thanks for your time,
Ram