Google tables of time and salary calculations
11 USD There are 2 workers with constantly changing working hours.
You need to create such a table so that they each can separate the start and end of the working day and the duration of the break.
The table should count the hours of that day and the total outcome of the week.
At the same time, in the individual table which is the client,
So that he can see all the hours of each worker and automatically calculate the wages.
There must be three short tables that are somehow linked to each other.
The example
Date of time break general
05.12 12:30-20:20 -30 7:20
06.12 7:40-20:00 -30 11:50
07.12 7:30-20:20 -30 12:20
08.12 7:30-20:30 -30 12:30
09.12 7:30-20:00 -30 12
10.12 7:30-17:00 0 9:30
Total week: 65:30 h
There are 2 workers with constantly changing working hours.You need to create such a table so that they each can separate the start and end of the working day and the duration of the break.And this is with your personal Google table.The table should count the hours of that day and the total outcome of the week.You can also add a monthly calculation, for example, in another tab.But the week is more important because the salary is paid by weeks.Also in the individual table which is the customer,
So that he can see all the hours of each worker and automatically calculate the wages.This means that we are talking about three different Google tables and more (depending on the number of employees) that are linked to each other by the following function:
HTTPS://support.google.com/a/users/answer/9308940?hl=ru&ref_topic=9327403
There must be three short tables that are somehow linked to each other.And make automatic calculation of time, calculation of break and calculation of wages.
The example
Date of time break general
05.12 12:30-20:20 -30 7:20
06.12 7:40-20:00 -30 11:50
07.12 7:30-20:20 -30 12:20
08.12 7:30-20:30 -30 12:30
09.12 7:30-20:00 -30 12
10.12 7:30-17:00 0 9:30
Total week: 65:30 h
Здравствуйте
Есть 2 рабочих с постоянно меняющейся рабочими часами.
Нужно создать такую таблицу чтобы они каждый отдельно смогли задавать начало и конец рабочего дня и длительность паузы.
И это со своей личной google таблицы.
А таблица должна сама считать часы того дня и общий итог недели.
Можно дополнительно ещё например в другой вкладке добавить месячный расчёт. Но недельный важнее потому что зарплата платится по неделям.
Также в отдельной таблице которая является клиента,
Чтобы он мог видеть все часы каждого рабочего и автоматическое подсчёт зарплаты.
Это значит что речь идёт здесь о три разных google таблиц и больше (зависит от количества рабочих) которые привязываются между собой следующей функцией: IMPORTRANGE
https://support.google.com/a/users/answer/9308940?hl=ru&ref_topic=9327403
Здесь должны создаваться короче три таблицы которые между собой как-то связываются.
И делают автоматический расчёт времени, вычитание паузы и расчёт зарплаты
Пример
Дата часы пауза общие
05.12 12:30-20:20 -30 7:20
06.12 7:40-20:00 -30 11:50
07.12 7:30-20:20 -30 12:20
08.12 7:30-20:30 -30 12:30
09.12 7:30-20:00 -30 12
10.12 7:30-17:00 0 9:30
Общая неделе : 65:30ч
Client's review of cooperation with Oleksii Kuzavov
Google tables of time and salary calculationsA great performer!
The work is done at the highest level!
More solutions were added than initially requested.
The video instructions were also created, although not agreed in advance.
I remained very pleased.
I will always work with you!
Freelancer's review of cooperation with Vlad Bez
Google tables of time and salary calculationsEverything is wonderful!
The customer is always in contact. It is clear and clear. Payment is timely.
-
1 day18 USD
335 3 0 1 day18 USD
Hello the Government.
I will be happy to help you with your task.
The task is simple and clear, there will be a few more questions, we will discuss in personal already.
After work, I will stay in contact if I suddenly need it.
I hope our cooperation with you.
Good day
by P.S. Payment can be discussed.
-
1 day11 USD
343 4 0 1 day11 USD
Hello to you.
I can make such a table. I suggest the details to be discussed in personal messages.
-
7 days111 USD
512 4 0 7 days111 USD
Good day, the government!Your request is very interesting.In addition to the extensive and profound experience in such projects, I sincerely enjoy such tasks.For more than 7 years I’ve been engaged in building processes in different companies, including developing and implementing tools for calculating different indicators.He has worked with more than 30 companies both in Ukraine and abroad.I am sure I will be able to help implement this project successfully.But in addition to the implementation of such tools, there is a deep expertise in:
Structuration and standardization of companies (organization, business processes, kpi, motivation, coordination, etc.)Construction of sales department
- ... and much more (depending on the external and internal situation in the company)
Ready to share more deeply the cases, plus to advise what is more effective to start with.From experience, it is more effective in personal communication, so I suggest to appoint a meeting in a convenient time for you.I hope for mutually beneficial cooperation.
by Anton
-
Winning proposal2 days11 USD
3615 113 7 1 Winning proposal2 days11 USD
Welcome to
The task is understood
I did this many times.
Ready to implement the project. I can start today.
Current freelance projects in the category Technical Documentation
Translation, editing, and layout of brochures/instructions
223 USD
Looking for a performer for comprehensive work with brochures and instructions. Required services: translation; editing and proofreading; document layout; transfer of color images from the original; preparation of printed and electronic versions. Output file: PDF. Please… Text Translation, Technical Documentation ∙ 3 days 3 hours back ∙ 30 proposals |
Kovel