# Tme Clock - Need Punch Out By Time

#### cherryonion

##### New Member
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!

### Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

#### Tetra201

##### MrExcel MVP
Is this what you need?

=1/3+B2-C2+D2

Replies
4
Views
716
Replies
2
Views
204
Replies
3
Views
1K
Replies
6
Views
993
Replies
0
Views
998

1,190,677
Messages
5,982,216
Members
439,769
Latest member
trungminh2802

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back