Need Formula to populate a cell +9 hours

Originally Posted by JBeaucaire

wWhat is the formula in I13?

That is what I am trying to figure out. I have uploaded the new workbook with new formulas.
There seems to be a problem with the formula in G13. If I enter 17:00 for Start Time
and 7:30 AM for End Time, the result in G13 is -10 Hour Worked. Then in H13 produces a result of #N/A.

2nd Problem:

I added 2 new cell's Named: Actual Change Of Start Time I13 and Day Off Achieved J13.
Not sure if its even possible but, can I13 show + 9 hours of time from E13(EndTime) if
the employee worked more than 15 hours?

Now for J13 Day Off Achieved ? Here is a scenario:

Employee starts work at 7:00 AM thru 3:30pm, then works a double shift in a 3:00pm crew
and works until 3:30 am.

7:00am to 3:30 (-lunch period) = 8.0 hours
3:30pm to 3:30 am = 12.0 hours
20.0 hours worked

3:30AM +9.0 hours rest period = 12:30pm start which is 5.5 hours into his/her workday.

If this employee is scheduled to start at 7:00am the next day he/she would be entitled to the day off with pay. More than five (5) hours of the employee's normally scheduled work tour lied within the nine (9) hour rest period.

So for J13 Day Off Achieved ? I would need YES or NO.



Thank You