Завершен

Excel, record IN and OUT time between specific tasks with multiple conditions -- 2

Hi, so what i really need is, if you take a look on the attached file, i need to record some times in "Master sheet" , pull the data from "Pivot Table Sheet" with these conditions:

1. IN TIME

Action = "EXT Main Gate In (13) (In)"

Date = report date from Master sheet (C2 cell)

--Time = between 17:00 and 19:00 for "Yellow" and "Green" shift

--Time = between 05:00 and 19:00 for "Blue" and "Red" shift

If that event will happened more than once between 17:00 and 19:00 for "Yellow" and "Green", return first time.

If that event will happened more than once between 05:00 and 07:00 for "Blue" and "Red", return first time.

2. OUT TIME

Action = "EXT Main Gate In (13) (In)"

Date = report date from Master sheet (C2 cell) for "Red" and "Blue"

Date = report date from Master sheet (C2 cell)+1 for "Yellow" and "Green"

Time between 05:00 and 07:00 for "Yellow" and "Green"

Time between 17:00 and 19:00 for "Blue" and "Red"

If that event will happened more than once between 05:00 and 07:00 "Yellow" and "Green", return LAST time.

If that event will happened more than once between 17:00 and 19:00 for "Blue" and "Red", return LAST time.

3. Break time

It is a variable, user can have 1/2/3 breaks. Maximum is 9.

Time between 2 events

GF WHS Out Turnstile (10) (In) - GF WHS In Turnstile (09) (In)

For "Yellow" and "Green"

Date between [report date from master sheet] and [report date from master sheet+1]

time between 18:00 and 06:00

Fot "Blue" and "Red"

date = [report date from master sheet]

time between 06:00 and 18:00

Навыки: Excel, Обработка данных, Ввод данных, Visual Basic, Microsoft Office

О клиенте:
( 0 отзыв(-а, -ов) ) Middlewich, United Kingdom

ID проекта: #33754442

Поручен:

Maherun75

"Dear Client, I specialize in Word or Excel VBA / Macro solutions and Web Scraping/Data Mining for your Excel workbooks. I will perform any tasks in Excel to automate your business. VBA macros, custom forms, charts, ta Больше

£35 GBP за 1 день
(8 отзывов(-а))
3.6

30 фрилансеров(-а) готовы выполнить эту работу в среднем за £117

(1167 отзывов(-а))
8.4
(479 отзывов(-а))
7.7
Teloquence

Excel expert at your services. Please check my past reviews for your reference. I have done similar projects before and I am confident we can deliver it to you. Looking forward to hear from you.

£135 GBP за 7 дней(-я)
(348 отзывов(-а))
7.8
(277 отзывов(-а))
7.0
ksriniravi

Greetings! Thanks for very detailed, specific and clear requirements leaving no scope for ambiguity. I can come up with a macro to automate updation of Master Worksheet / tab based on data from Pivot Table Worksheet / Больше

£30 GBP за 1 день
(247 отзывов(-а))
7.1
(211 отзывов(-а))
6.6
best4best

Hi, I am an Excel expert. I can create the formulas to get the required data about employees activities as exlained in the description. Please take a look at my portfolio and reviews about Excel projects and consider Больше

£90 GBP за 2 дней(-я)
(213 отзывов(-а))
6.6
(190 отзывов(-а))
6.5
PERPETUAL0

Hello there i can make the fully fomrating conditional with formula to record the out and in regards ILYAS

£100 GBP за 2 дней(-я)
(134 отзывов(-а))
5.7
hamidr2020

Hello, I have read your requirements for In time, Out time and Break time and checked the sample_swipe file. I am interested in your project, however, would like to chat for clarity on a couple of matters. I am an Exc Больше

£70 GBP за 1 день
(57 отзывов(-а))
5.4
(60 отзывов(-а))
5.8
(88 отзывов(-а))
5.4
(5 отзывов(-а))
3.3
sumedhahansi1

Hello dear. I have read all description and want to ask some questions to fill it. I will do my best for this project and correct details may attached with 100% accuracy. I am experienced and educated office assistant Больше

£75 GBP за 1 день
(1 отзыв)
1.4
Haseebuddinkhan

Dear Sir, Through your advertisement, I learned about your present career opportunities. I am extremely interested in securing a position with your company. I am finalists at the Institute of Cost and Management Acc Больше

£135 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
singhhitesh2013

I am an experienced employee, my typing of data entry is 40 wpm and I will do your work with full sincerity, hard work and time, I request you to give me a chance to serve you.

£135 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
anikurmotin

Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes i can do it, because i have experienced Больше

£135 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
Abhichourey26

i have read your brief and understand your requirement i can do it with my advanced excel skills. And I am happy with working you

£99 GBP за 6 дней(-я)
(0 отзывов(-а))
0.0
savangadhiya63

i am data entry work experience 3 years .my typing accuracy is 90% and i belive in perfect timing and client satisfaction

£135 GBP за 7 дней(-я)
(0 отзывов(-а))
0.0
rishiakhilesh

Hey!! I have totally understand the business objective behind your problem & glad to share that i can totally help you there. Being into data analytics from last 4 years i have been doing a lot of excel python VBA aut Больше

£62 GBP за 2 дней(-я)
(0 отзывов(-а))
0.0