I want to create a chart that would tell give me the formula for the hours for my employees. For example if one comes in at 7am and out by 3:30pm (with 1/2 hour lunch deduction)how many hours did that person worked.
I am very new a excel; so please help! I need the formula!
Thanks!