cherryonion
New Member
- Joined
- Dec 15, 2016
- Messages
- 1
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.
<colgroup><col><col span="4"><col><col></colgroup><tbody>
</tbody>
HOURS column:
=SUM(((C2-B2)+F2-D2))*24
Thanks!
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!