jladkins69
New Member
- Joined
- Jun 12, 2018
- Messages
- 1
I'm trying to modify an existing timesheet that I created to track employee hours worked. I need to add some additional columns in order to calculate time with a large break in between work.
For example: I have an employee that works 7:00 AM to 2:00 PM then will pick up again at 7:00 PM to 2:30 AM....
I can think of 2 options to perform this:
Option 1: Set the initial start and final end time - add a column for total break hours - then subtract the break hours from the total calculated work hours
Option 2: I can add additional columns for 1st shift total and 2nd shift total and add together.
Which option would be better? How do I do the formula so it will work?
Below is the original spreadsheet that I created..
=IF(AND(ISNUMBER(E5),ISNUMBER(D5)),MOD(E5-D5,1),0)*24
<tbody>
</tbody>
For example: I have an employee that works 7:00 AM to 2:00 PM then will pick up again at 7:00 PM to 2:30 AM....
I can think of 2 options to perform this:
Option 1: Set the initial start and final end time - add a column for total break hours - then subtract the break hours from the total calculated work hours
Option 2: I can add additional columns for 1st shift total and 2nd shift total and add together.
Which option would be better? How do I do the formula so it will work?
Below is the original spreadsheet that I created..
=IF(AND(ISNUMBER(E5),ISNUMBER(D5)),MOD(E5-D5,1),0)*24
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>