Jadezircon
New Member
- Joined
- Jul 25, 2013
- Messages
- 11
Hello, this is my first post. I need some help. This is a problem to be solved and it has been awhile since I had to calculate something this complex. The sales person is in a store working but the time sheets show more than 24 hours per day, up to 37 hours working and paid for. The scenario is below. Basically
Column A is the Date by day month and year
Column B is the time in by department
Column C is the time out by the department.\
There are up to 7 departments more in two columns each per department in and out shown below.
Each department pays differently and the timesheets overlap.
First I need to calculate across overlapping hours, then apply the correct rate to the overlap for reimbursement.
Your guidance would be greatly appreciated.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL></COLGROUP>
Column A is the Date by day month and year
Column B is the time in by department
Column C is the time out by the department.\
There are up to 7 departments more in two columns each per department in and out shown below.
Each department pays differently and the timesheets overlap.
First I need to calculate across overlapping hours, then apply the correct rate to the overlap for reimbursement.
Your guidance would be greatly appreciated.
| Jane works at a Department store like JC Penny's, however there is no clock punch in or out. </SPAN> | |||||||||||||
| Military Time</SPAN> | When Jane works in Jewelry or Cosmetics, she is paid $16.00 per hour</SPAN> | ||||||||||||
| =time plus 12 hours</SPAN> | When Jane works in the Shoe Department she only makes $10.00 per hour</SPAN> | ||||||||||||
| Midnight is 0:00</SPAN> | When Jane is on the floor directing people, she is paid only $8.00 per hour</SPAN> | ||||||||||||
| Noon is 12:00</SPAN> | When Jane is a greeter at the front door she make $7.90 per hour</SPAN> | ||||||||||||
| 3</SPAN> | I need to be fair to the employee and only request the lowest paid overlapping hours back. </SPAN></SPAN> | ||||||||||||
| $16.00 In Jewelry </SPAN> | Out of Jewelry</SPAN> | $16.00 In Cosmetics</SPAN> | Out of Cosmetics</SPAN> | $10.00 In the Shoe Department</SPAN> | Out of the Shoe Department</SPAN> | $8.00 In Directing People</SPAN> | Out Directing People</SPAN> | $7.90 In Greeting People</SPAN> | $7.90 Greeting People Out</SPAN> | $7.80 In Janes Cosmetics</SPAN> | Out of Janes Cosmetics</SPAN> | $7.80 In Janes Cosmetics</SPAN> | |
| Date</SPAN> | |||||||||||||
| 1/1/2011</SPAN> | 21:30</SPAN> | 11:20</SPAN> | |||||||||||
| 1/2/2011</SPAN> | 13:00</SPAN> | 19:00</SPAN> | |||||||||||
| 1/3/2011</SPAN> | 16:00</SPAN> | 6:00</SPAN> | 6:30</SPAN> | 10:30</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 12:00</SPAN> | 14:00</SPAN> | 13:00</SPAN> | ||
| 1/4/2011</SPAN> | 16:00</SPAN> | 6:00</SPAN> | 6:30</SPAN> | 10:30</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 12:00</SPAN> | 14:00</SPAN> | 21:30</SPAN> | 11:20</SPAN> | 13:00</SPAN> | ||
| 1/5/2011</SPAN> | 16:00</SPAN> | 6:00</SPAN> | 6:30</SPAN> | 10:30</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 12:00</SPAN> | 14:00</SPAN> | 13:00</SPAN> | ||||
| 1/6/2011</SPAN> | 16:00</SPAN> | 6:00</SPAN> | 6:30</SPAN> | 10:30</SPAN> | 14:00</SPAN> | 16:00</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 12:00</SPAN> | 14:00</SPAN> | 21:30</SPAN> | 11:20</SPAN> | 13:00</SPAN> |
| 1/7/2011</SPAN> | 16:00</SPAN> | 6:00</SPAN> | 6:30</SPAN> | 8:30</SPAN> | 14:00</SPAN> | 16:00</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 12:00</SPAN> | 14:00</SPAN> | 13:00</SPAN> | ||
| 1/8/2011</SPAN> | 5:00</SPAN> | 9:00</SPAN> | 21:30</SPAN> | 11:20</SPAN> | 13:00</SPAN> | ||||||||
| 1/9/2011</SPAN> | 12:00</SPAN> | 18:00</SPAN> | 5:00</SPAN> | 9:00</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL span=2><COL><COL><COL></COLGROUP>
