Закрыт

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

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 отзыв(-а, -ов) ) Chicago, United States

ID проекта: #33754902

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

(684 отзывов(-а))
8.4
(278 отзывов(-а))
7.0
(178 отзывов(-а))
6.7
AccountantArman

"Sir, I am Excel Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 6 years of experience from worlds leading Accountan Больше

$30 USD за 1 день
(175 отзывов(-а))
6.5
(136 отзывов(-а))
6.4
(74 отзывов(-а))
5.9
nimiwebjuggler

Hi, I'm an Expert Virtual Assistant providing services of Data Entry, Web Research, Data Mining, Data Processing, PDF conversion, Microsoft Office work, Photoshop work, and much more! I have experience of more than 2 y Больше

$49 USD за 1 день
(89 отзывов(-а))
6.0
(68 отзывов(-а))
5.9
(140 отзывов(-а))
6.1
merinsinha

Excel Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platfro Больше

$40 USD за 1 день
(152 отзывов(-а))
5.7
rameshraja86

Hi There, I Can create Pivot tables based on the conditions mentioned. I am a professional Excel developer in formula and VBA. Please check my profile for my previous projects. Contact me for further details Thank y Больше

$60 USD за 1 день
(31 отзывов(-а))
4.9
(27 отзывов(-а))
4.0
nandu1290

Hello sir I have gone through your project details. I am interested in this project. Please give me a chance to work with you. I have many years experience in this field. I am ready to start right now. Thank you Namdu

$10 USD за 1 день
(27 отзывов(-а))
3.9
rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

$29 USD за 1 день
(9 отзывов(-а))
3.7
Maath

hello , I can do this now if hired by you , I will provide high quality results . Thank you __________________

$10 USD за 1 день
(16 отзывов(-а))
3.9
SIBTEHASSANBUTT

Hi there, I have read your project entitled “Excel, record IN and OUT time between specific tasks with multiple conditions ” I am a professional accountant dealing with PowerBi, well versed with data analytics, using Больше

$20 USD за 7 дней(-я)
(12 отзывов(-а))
3.8
abatsis

Hello, I am a PhD Industrial Engineer and have experience in data science,and can work on projects in the following fields: Data Modeling, Data Analysis, Flow Chars, ERD Diagrms, Data Entry, IoT, Industrial IoT, Power Больше

$50 USD за 7 дней(-я)
(9 отзывов(-а))
3.5
rahulg5466

--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Больше

$30 USD за 1 день
(18 отзывов(-а))
3.6
(4 отзывов(-а))
2.7
huyenluu921

Hello there! I'm good at Excel Data Processing. I can help you to retrieve data from Excel. Please chat me to discuss! Thanks.

$20 USD за 7 дней(-я)
(1 отзыв)
0.6