Dear Experts,
I tried so many times but cant get the formula what to use for it. i am sure my experts Excelforum family will help me out from this confusing scenario. below is the explanation what kind of formula i need to add also attaching a file.
I need to extract Short Leave and Half Day from the IN and OUT timings.
if IN time is before 8:30 AM than show me on time or blank.
if IN time is greater than 8:30 AM and before 10:10 AM it will consider Short Leave.
if IN time is greater than 12:10 PM it will be Half Day. Same for the OUT.
if OUT time is greater than 15:10 PM it will be Short Leave.
Thanks in advance for your precious time and help.
Bookmarks