Hi,
Can someone here know the formula on how to get if the employee took Pre/Post-shift Overtime based on the given table?
I have attached the file for reference.
On Tab Table, Column J put if the employee took Pre or Post Overtime based On column G and column H and based on the reference table on Tab REF.
Hoping the someone here can help me to solve this mystery.
Your feedback is highly appreciated.
Please add (manual) expected results to your file.
Hi albert,
See if this attached does what you need. I needed to format your days a little different so they were text. I also reformatted your ref table.
Under Over Time.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks MarvinP.
However, i have attached the file again for more detailed one.
can anyone here, please.
Hi albert,
Can you tell me what was wrong with my first answer? Do I need to tell if the overtime was pre or post? Can you show the corrected answers?
Yes, Boss MarvinP. On Column J it supposed to be pre or post Shift Ot and I need to add another Column to compute hours from Pre or Post Shift overtime.
and the from the ref tab table it should be the lookup or reference if the login or log out of an employee whether they fall on pre or post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks