Hello Forum,
I am hoping that you can help me out.
I am trying to build a timesheet for work.
I have the employees start time in cell A1 and their end time in cell A2. In cell A3 I have their hours, which the formula I have is =sum(A2-A1) to find out the hours worked (using the 24hr clock system).
My issue is this - I need to create an IF statement which will deduct a half hour lunch if their start or end time is 12:00:00 PM.
Example:
Johnny works from 8am to 5pm.
In cell A1 entered is 08:00:00 and in cell A2 it says 17:00:00. I need the cell that calculates the hours (A3) to minus the half hour lunch at noon only IF noon is punched in.
Sometimes they work on different projects throughout the day and I need to tally that.
Example:
Johnny starts at 8am and works until 10am. The formula I have now will easily calculate 2 hrs worked. Johnny starts working again at 10:30am and works until 1pm that afternoon. I now need an if statement in there to deduct a half hour for lunch.
Any ideas anyone??
Help is greatly appreciated!
Bookmarks