Encerrado

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

Habilidades: Excel, Processamento de dados, Processamento de Dados, Visual Basic, Microsoft Office

Sobre o Cliente:
( 0 comentários ) Chicago, United States

ID do Projeto: #33754902

57 freelancers estão ofertando em média $55 nesse trabalho

(684 Comentários)
8.4
(278 Comentários)
7.0
(178 Comentários)
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 Mais

$30 USD em 1 dia
(175 Comentários)
6.5
(136 Comentários)
6.4
(74 Comentários)
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 Mais

$49 USD em 1 dia
(89 Comentários)
6.0
(68 Comentários)
5.9
(140 Comentários)
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 Mais

$40 USD em 1 dia
(152 Comentários)
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 Mais

$60 USD em 1 dia
(31 Comentários)
4.9
(27 Comentários)
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 em 1 dia
(27 Comentários)
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 em 1 dia
(9 Comentários)
3.7
Maath

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

$10 USD em 1 dia
(16 Comentários)
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 Mais

$20 USD in 7 dias
(12 Comentários)
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 Mais

$50 USD in 7 dias
(9 Comentários)
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 Mais

$30 USD em 1 dia
(18 Comentários)
3.6
(4 Comentários)
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 in 7 dias
(1 Comentário)
0.6