Đã hoàn thành

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

Kĩ năng: Excel, Xử lí dữ liệu, Nhập liệu, Visual Basic, Microsoft Office

Về khách hàng:
( 0 nhận xét ) Middlewich, United Kingdom

ID dự án: #33754442

Được trao cho:

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 Thêm

£35 GBP trong 1 ngày
(8 Đánh Giá)
3.6

30 freelancer chào giá trung bình£117 cho công việc này

(1167 Nhận xét)
8.4
(479 Nhận xét)
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 trong 7 ngày
(348 Nhận xét)
7.8
(277 Nhận xét)
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 / Thêm

£30 GBP trong 1 ngày
(247 Nhận xét)
7.1
(211 Nhận xét)
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 Thêm

£90 GBP trong 2 ngày
(213 Nhận xét)
6.6
(190 Nhận xét)
6.5
PERPETUAL0

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

£100 GBP trong 2 ngày
(134 Nhận xét)
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 Thêm

£70 GBP trong 1 ngày
(57 Nhận xét)
5.4
(60 Nhận xét)
5.8
(88 Nhận xét)
5.4
(5 Nhận xét)
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 Thêm

£75 GBP trong 1 ngày
(1 Nhận xét)
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 Thêm

£135 GBP trong 7 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

£135 GBP trong 7 ngày
(0 Nhận xét)
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 trong 6 ngày
(0 Nhận xét)
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 trong 7 ngày
(0 Nhận xét)
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 Thêm

£62 GBP trong 2 ngày
(0 Nhận xét)
0.0