Calculating a Clock-Out Time for the Week

[gd6noob]

Hi guys,

Just a quick question on how to get a predicted Clock Out time for the week with 60.5 hours MAX.
Column1 is the total so far in the week.
Clock In Time is Todays clock in time.
If the Recommended Clock out time is 12 hours or more away, have it display a text.

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1060"]
<tbody>[TR]
[TD="class: xl66, width: 100"]Employee ID[/TD]
[TD="class: xl67, width: 223"]Employee Name[/TD]
[TD="class: xl67, width: 247"]Manager[/TD]
[TD="class: xl68, width: 87"]Time[/TD]
[TD="class: xl68, width: 87"]Column1[/TD]
[TD="class: xl68, width: 104"]Clock In Time[/TD]
[TD="class: xl67, width: 212"]Recommended Clock Out Time[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 1060"]
<tbody>[TR]
[TD="class: xl66, width: 100, align: right"]blank[/TD]
[TD="class: xl67, width: 223"]blank[/TD]
[TD="class: xl67, width: 247"]XX[/TD]
[TD="class: xl68, width: 87, align: right"]14:04:00[/TD]
[TD="class: xl69, width: 87, align: right"]46:35[/TD]
[TD="class: xl68, width: 104, align: right"]07:22:00[/TD]
[TD="class: xl69, width: 212"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advanced

 

[gd6noob]

Here is a better image of my spreadsheet.

So basically, 60 hours - Total Time = Recommended Clock out time, if they have a clock in time (column F). If the remaining hours is greater then 12 hours, have it display a text (Safe)

 

[gd6noob]

Forgot to mention, the Recommended clock out time needs to add addtional 30 min

So lets say someone has worked 55 hours and has clocked in today at 730am, he needs to clock out by 1pm.