Very new to excel programming and 1st post here.
The attached workbook has some examples.
I have inserted the drop-down time lists to choose Actual Start Time & End Time.
30 minutes have been deducted for the employee's lunch period, to show Total Hours Worked.
I need a formula to add 9 hours time to cell H13 from the time in cell E13.
In our company, if an employee works more than 15 hours continuously the employee is entitiled to a 9 hour rest period.
example:
If possible, could the formula populate the word NO in the Change Of Start Time cell, if the criteria (15.1)hours was not achieveed in cell G13?
example
Every 6 minutes is a point.
Thank You,
KDL
Bookmarks