Closed

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

Skills: Excel, Data Processing, Data Entry, Visual Basic, Microsoft Office

About the Client:
( 0 reviews ) Chicago, United States

Project ID: #33754902

57 freelancers are bidding on average $55 for this job

(684 Reviews)
8.4
(278 Reviews)
7.0
(178 Reviews)
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 More

$30 USD in 1 day
(175 Reviews)
6.5
(136 Reviews)
6.4
(74 Reviews)
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 More

$49 USD in 1 day
(89 Reviews)
6.0
(68 Reviews)
5.9
(140 Reviews)
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 More

$40 USD in 1 day
(152 Reviews)
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 More

$60 USD in 1 day
(31 Reviews)
4.9
(27 Reviews)
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 in 1 day
(27 Reviews)
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 in 1 day
(9 Reviews)
3.7
Maath

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

$10 USD in 1 day
(16 Reviews)
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 More

$20 USD in 7 days
(12 Reviews)
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 More

$50 USD in 7 days
(9 Reviews)
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 More

$30 USD in 1 day
(18 Reviews)
3.6
(4 Reviews)
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 days
(1 Review)
0.6