Fermé

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

Compétences : Excel, Traitement de Données, Saisie de Données, Visual Basic, Microsoft Office

Concernant le client :
( 0 commentaires ) Chicago, United States

Nº du projet : #33754902

57 freelances font une offre moyenne de 55 $ pour ce travail

(684 Commentaires)
8.4
(278 Commentaires)
7.0
(178 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(175 Commentaires)
6.5
(136 Commentaires)
6.4
(74 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(89 Commentaires)
6.0
(68 Commentaires)
5.9
(140 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(152 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(31 Commentaires)
4.9
(27 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(27 Commentaires)
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!

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.7
Maath

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(16 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(12 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(9 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(18 Commentaires)
3.6
(4 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
0.6