Tme Clock - Need Punch Out By Time

[cherryonion]

Hi! I am working on a time clock sheet to help track hours worked throughout the week. It's pretty basic, but I would like to have a column that indicates what time an employee would need to punch out by in order to have worked for 8 hours.

Here is how it looks currently. The formula I'm using to calculate total hours is below as well. The idea being that after an employee enters their In for Day, Out for Lunch, and In for Lunch, it would calculate what time they would need to punch OUT BY in order to maintain 8 hours.

	IN	OUT	IN	OUT BY	OUT ACTUAL	HOURS
Monday	8:23 AM	12:00 PM	12:20 PM		4:23 PM	7.67
Tuesday	8:15 AM	12:00 PM	12:30 PM		4:45 PM	8.00
Wednesday						0.00
Thursday						0.00
Friday						0.00
						15.67
					OT	24.33

<colgroup><col><col span="4"><col><col></colgroup><tbody>
</tbody>

HOURS column:
=SUM(((C2-B2)+F2-D2))*24


Thanks!

 

[Tetra201]

Is this what you need?

=1/3+B2-C2+D2