Guys I need help, I am currently creating a timesheet for my worker however I have stumbled across a bit of a issue.
Below is the timesheet to help understand the view and layout:
Timesheet.jpg
Column D: Time Start
Column E: Time Finish
Column F: Overtime
Column G: Total Hours - Uses the Formula: =(E10+F10-D10)* 24
Column I: Work Type Reason - Has a dropdown list of various reasons e.g, Worked without Lunch Break, Worked with Lunch Break, Holiday, Sickness
I am trying to get the Total Hours to deduct 1 from the Column if the "Worked with a Lunch Break" is selected from the dropdown.
Explanation for this is because the normal working hours total 8.5hrs however if they work 1 hour unpaid lunch 1 needs to be subtracted from the total working hours. I need this column to exist due to knowing the reasons in the dropdown however for this particular on I require a formula of such that detects this reason and automatically subtracts 1 from the Total hours Column.
Please help....
Bookmarks