IF Formula for TIME Calculations

Hi, 

I want to use formula for TIME calculations. For Example I have the data of in punch and out punch and I want to calculate who came after 9:30am and leave before 16:00pm. I will get data monthly for all employees at a time.

I tried lot of combinations but could not suceed, kindly help me.

Anjani

 

 

By: Anjani

Leave a Reply

Your email address will not be published. Required fields are marked *