Switch to English version?

Yes

Переключитись на українську версію?

Так

Переключиться на русскую версию?

Да

Przełączyć się na polską wersję?

Tak

Login
Registration
- Welcome to Freelancehunt
  
  Work risk-free, saving time and money
  
  Login Registration

Post your project for free and start receiving proposals from freelancers within minutes after publication!

33 USD

Working hours in Excel

33 USD

Databases & SQL, Java

6 out of 6

project complete

publication
open for proposals
terms confirmation
reservation
work underway
project complete

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.

Applications 2

Application viewing is only available registered users.

Client's review of cooperation with Zevs N.

Quality

Professionalism

Cost

Contactability

Deadlines

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

Andrey Kutnev | Safe

Freelancer's review of cooperation with Andrey Kutnev

Payment

Task setting

Clarity of requirements

Contactability

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!

Zevs N. | Safe

by default date online rating cost completion time

33 USD

Mykhailo Yatsyshyn

5 1

33 USD

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.

Show original

Translate

3 January 2018, 9:36

33 USD

Evhenii Ksenych

33 USD

Hello to you. Ready to run on Asp .Net.
The Web App.
What sql base do you use? I would like to see the structure of the base.

Show original

Translate

2 January 2018, 22:56

Winning proposal33 USD

Zevs N.

Winning proposal33 USD

Good time for the day! I can automatize your decision based on the proposed template. (Excel and Macros)

Show original

Translate

2 January 2018, 22:32

1 proposal concealed

Volodymyr Todorov

Доброї ночі) Скажіть будь ласка, замовлення термінове? До якого числа потрібно зробити?

Andrey Kutnev

срок до 20-го чосла

Dmitry Thorzhevsky

Я бы реккомендовал воспользоваться готовыми бизнес решениями на эту тему, а не писать свое. Будет однозначно дешевле и скорее всего более качественно

Current freelance projects in the category Databases & SQL

Need a 1C specialist for refinements and development. I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 12 hours 31 minutes back ∙ 9 proposals
Restoring Instagram after a ban On March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 23 hours 37 minutes back ∙ 4 proposals
CRM system for Railway Logistics Creation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 1 day 11 hours back ∙ 38 proposals
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C: 45 USD Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 4 days 6 hours back ∙ 16 proposals	45 USD
Accounting, planning, and sales system for a mushroom farm 602 USD Here is the complete, final text of the Technical Assignment (TA). It combines all your requirements: 16 chambers, 20 contractors, a schedule by days, accounting for containers, profitability calculation, and a mandatory division into three grades of mushrooms. You can fully… Databases & SQL, Client Management & CRM ∙ 6 days 10 hours back ∙ 57 proposals	602 USD

Andrey Kutnev

Riga 1

Working hours in Excel

Client's review of cooperation with Zevs N.

Freelancer's review of cooperation with Andrey Kutnev

Current freelance projects in the category Databases & SQL

Need a 1C specialist for refinements and development.

Restoring Instagram after a ban

CRM system for Railway Logistics

Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:

Accounting, planning, and sales system for a mushroom farm