Excel, record IN and OUT time between specific tasks with multiple conditions -- 2
Бюджет £20-250 GBP
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
30 фрилансеров(-а) готовы выполнить эту работу в среднем за £117
Excel expert at your services. Please check my past reviews for your reference. I have done similar projects before and I am confident we can deliver it to you. Looking forward to hear from you.
Greetings! Thanks for very detailed, specific and clear requirements leaving no scope for ambiguity. I can come up with a macro to automate updation of Master Worksheet / tab based on data from Pivot Table Worksheet / Больше
Hello there i can make the fully fomrating conditional with formula to record the out and in regards ILYAS
Hello, I have read your requirements for In time, Out time and Break time and checked the sample_swipe file. I am interested in your project, however, would like to chat for clarity on a couple of matters. I am an Exc Больше
Hello dear. I have read all description and want to ask some questions to fill it. I will do my best for this project and correct details may attached with 100% accuracy. I am experienced and educated office assistant Больше
Dear Sir, Through your advertisement, I learned about your present career opportunities. I am extremely interested in securing a position with your company. I am finalists at the Institute of Cost and Management Acc Больше
I am an experienced employee, my typing of data entry is 40 wpm and I will do your work with full sincerity, hard work and time, I request you to give me a chance to serve you.
Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes i can do it, because i have experienced Больше
i have read your brief and understand your requirement i can do it with my advanced excel skills. And I am happy with working you
i am data entry work experience 3 years .my typing accuracy is 90% and i belive in perfect timing and client satisfaction
Hey!! I have totally understand the business objective behind your problem & glad to share that i can totally help you there. Being into data analytics from last 4 years i have been doing a lot of excel python VBA aut Больше
