Excel - adapt existing formula and spreadsheet to calculation holiday hours and days
- or -
Post a project like this1867
$
- Posted:
- Proposals: 8
- Remote
- #2301697
- Awarded
Lead generation, Web research,Data entry,Excel expert For Linkedin, facebook etc.
Rangpur
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
14494732517640256615220874401788290137182724235612583356
Description
Experience Level: Entry
Hi,
This is the spreadsheet that we use to track vacation, I would like it adapted so that instead of entering V for vacation, we enter the number of hours vacation taken and we count the days and hours taken. The total number of hours taken should be summed and displayed as well as total vacation (previously V). For instance, If 5 hours is entered for April 1st, the employee was on vacation on that day so the vacation count will be 1 and the hours 5 this month. If they then take 6 hours off May 1st, April figures is unchanged but May is 1 and 6 hours this month, the count this year should therefore be 2 days vacation and 10 hours.
Also, each employee will need some new columns; to have a column where we enter the holiday allowance in days and hours. The holiday taken in days and hours that is calculated and displayed should subtracted from the allowance and the balance for hours and days displayed. The holiday taken should be displayed as This month and This year as the current leaves are.
All other functionality should remain the same, for instance we will still need to track absence, maternity and sickness, etc in the same way but these should not be counted as vacation - only as leaves.
This is the spreadsheet that we use to track vacation, I would like it adapted so that instead of entering V for vacation, we enter the number of hours vacation taken and we count the days and hours taken. The total number of hours taken should be summed and displayed as well as total vacation (previously V). For instance, If 5 hours is entered for April 1st, the employee was on vacation on that day so the vacation count will be 1 and the hours 5 this month. If they then take 6 hours off May 1st, April figures is unchanged but May is 1 and 6 hours this month, the count this year should therefore be 2 days vacation and 10 hours.
Also, each employee will need some new columns; to have a column where we enter the holiday allowance in days and hours. The holiday taken in days and hours that is calculated and displayed should subtracted from the allowance and the balance for hours and days displayed. The holiday taken should be displayed as This month and This year as the current leaves are.
All other functionality should remain the same, for instance we will still need to track absence, maternity and sickness, etc in the same way but these should not be counted as vacation - only as leaves.
Marlon S.
100% (3)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
3 Apr 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Marlon
What is your expected timeline? -
How Marlon S., how many workbooks in your Excel spreadsheet run to? And is this an ongoing project, month to month? Thanks, John.
768711768681
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies