Kapalı

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

Beceriler: Excel, Veri İşleme, Veri Girişi, Visual Basic, Microsoft Office

Müşteri Hakkında:
( 0 değerlendirme ) Chicago, United States

Proje NO: #33754902

Bu iş için 57 freelancer ortalamada $55 teklif veriyor

(684 Değerlendirme)
8.4
(278 Değerlendirme)
7.0
(178 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(175 Değerlendirme)
6.5
(136 Değerlendirme)
6.4
(74 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(89 Değerlendirme)
6.0
(68 Değerlendirme)
5.9
(140 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(152 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(31 Değerlendirme)
4.9
(27 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)
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!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(9 Değerlendirme)
3.7
Maath

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(16 Değerlendirme)
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 Daha Fazla

$20 USD in 7 gün içinde
(12 Değerlendirme)
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 Daha Fazla

$50 USD in 7 gün içinde
(9 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(18 Değerlendirme)
3.6
(4 Değerlendirme)
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 gün içinde
(1 Yorum)
0.6