Excel, record IN and OUT time between specific tasks with multiple conditions
Бюджет $10-30 USD
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
57 фрилансеров(-а) готовы выполнить эту работу в среднем за $55
"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 Больше
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 Больше
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 Больше
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 Больше
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
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!
hello , I can do this now if hired by you , I will provide high quality results . Thank you __________________
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 Больше
--------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 Больше
Hello there! I'm good at Excel Data Processing. I can help you to retrieve data from Excel. Please chat me to discuss! Thanks.
