12345678910111213141516171819202122232425262728293031323334353637383940414243A B C D E F G HLegal Staff Billable Hours LogEmployee Name Swinson DavidEmployee Number 6287Billable Rate 165.00$ Mon Tue Wed Thu Fri Sat SunDates Worked 22-Jul 23-Jul 24-Jul 25-Jul 26-Jul 27-Jul 28-JulHudson 4.00 4.00 1.00 2.25 Smith 4.00 4.00 4.00 Aturo 1.50 2.50 3.50 1.00 4.00 Proctor 2.25 2.25 2.25 3.00 2.25 Total Billable Hours Per Day 7.75 8.75 6.25 7.50 7.25 6.25 4.00 Daily Bill $1,278.75 $1,443.75 $1,031.25 $1,237.50 $1,196.25 $1,031.25 $660.00Bill Total for Week $7,878.75Mon Tue Wed Thu Fri Sat SunDates Worked 29-Jul 30-Jul 31-Jul 1-Aug 2-Aug 3-Aug 4-AugHudson 3.50 3.00 1.00 2.50 1.00 Smith 2.00 2.00 3.00 Aturo 3.00 2.00 1.00 1.00 1.00 2.00 Proctor 2.25 1.00 2.25 4.00 4.00 4.00 Total Billable Hours Per Day 7.25 6.50 8.25 9.00 7.50 5.00 2.00 Daily Bill Total $1,196.25 $1,072.50 $1,361.25 $1,485.00 $1,237.50 $825.00 $330.00Bill Total for Week $7,507.50 - 0.50 1.00 1.50 2.00 2.50 3.00 3.50 4.00 4.5029-Jul 30-Jul 31-Jul 1-Aug 2-Aug 3-Aug 4-AugWeek of July 29Hudson Smith Aturo ProctorEX2019-ChallengeYourself-1-3-solution.xlsxSAMPLE