Working hours in Excel

Databases & SQL, Java — incorrectly specified categories?

34 USD

Client's review of cooperation with Zevs N.

Working hours in Excel

34 USD

The impressions of cooperation are the most positive. The complex work time accounting system in Excel is done professionally and timely. I recommend cooperation.

5.0

Andrey Kutnev

Reciprocal Feedback

10 January 2018

Freelancer's review of cooperation with Andrey Kutnev

Working hours in Excel

34 USD

Strong TZ and quick response. A good customer with a good understanding of the assigned task.
I was pleased with the collaboration and the work provided!

5.0

Project translated automatically. Log in or register, to view the original You need a program in Excel to calculate the working time.A description of the program in Excel.The program must consist of 12 or 13 sheets, depending on the implementation, per sheet per month and, if necessary, one sheet with the source data.The data is on a sql server and is easily imitated in Excel.Required functionality: 1.The program has a place to enter the current year based on which data from sql should be uploaded.2. the user selects the enterprise (it is in the base) and presses the "Rating" button, after which the program must add to each sheet the necessary number of lines with the names of employees and insert in the cells opposed to the name and the number of hours spent based on the data uploaded from the sql base.ThreeThe program provides for the possibility of introducing the time of lunch, which will be automatically removed from the working time.(If the data is not entered, then nothing is taken away) 4.It also provides for the possibility of indicating the maximum working hours.For example, if the number 8 is indicated, the working time up to 8 hours is shown on the basis of current data, and the working time more than 8 hours (e.g. 9:30) is reflected as 8 hours.and 5.In the source data may be several temporary data per day, the program must count the time between the first and last time per day, 1.(06.12.2017 09:19:52) 2.(06.12.2017 14:11:25) 3.(06.12.2017 14:29:17) 4.(06.12.2017 18:01:02) but if possible to provide the counting of the absence - a number input (e.g. 15 minutes) and if the time between any or any temporary cuts exceeds this chaos, it is counted out of the working hours.6 .If the employee was absent in the accounting period, the cell shall be inserted in point No. 7.The attached file has a January sheet, where the desired form is available.There is also the desired color indication based on the conditions, but at the moment the condition works only on a specific number, if possible you need to do so that the red color indicates time >10 hours and the yellow 7 hours.In the file with data.

Applications2

XLSX

Employee absence schedule1.xlsx

225KB

XLSX

Employee absence schedule1.xlsx

225KB

Proposals 4 Rejected 1 Discussions 3

Mykhailo Yatsyshyn

5 1

Projects 6
Rating -
Rating 581

Budget: 1500 UAH Deadline: 5 days

Good day . Ready to fulfill your task. I will tell you as soon as I have experience in developing automated reports using Excel. The technology is ready to be discussed by mail.