In column C of the HR export worksheet, extract the number of hours each employee has worked. Make sure the result is a number and there are no extra spaces extracted with the value. [Hint: Use an asterisk ("hour*") as a wildcard to cover both "hour" and "hours" data entries.]

Transcribed Image Text:

County HR Time On Project Employee ID 60011 57724 47727 28702 20386 50276 20992 17633 76673 67955 70484 86035 24928 21742 31978 77429 59868 65514 19715 23972 88355 12502 68387 12443 64970 75673 56551 72027 62777 30637 64886 33295 19144 Column1 Data Export 96 hours 120 hour 40 hours 12 hour 8 hour 36 hour 132 hours 165 hours 40 hours 40 hours 40 hours 40 hour 40 hours 20 hours 10 hours 30 hours 32 hour 40 hourly 32 hourly 96 hours 128 hours 64 hour 64 hour 40 hour 56 hour 56 hours 24 hours 24 hourly 24 hour 96 hours 120 hour 40 hours 12 hour Column2 Hours County HR Time On Project Employee ID 60011 57724 47727 28702 20386 50276 20992 17633 76673 67955 70484 86035 24928 21742 31978 77429 59868 65514 19715 23972 88355 12502 68387 12443 64970 75673 56551 72027 62777 30637 64886 33295 19144 Column1 Data Export 96 hours 120 hour 40 hours 12 hour 8 hour 36 hour 132 hours 165 hours 40 hours 40 hours 40 hours 40 hour 40 hours 20 hours 10 hours 30 hours 32 hour 40 hourly 32 hourly 96 hours 128 hours 64 hour 64 hour 40 hour 56 hour 56 hours 24 hours 24 hourly 24 hour 96 hours 120 hour 40 hours 12 hour Column2 Hours

Answer rating: 100% (QA)

The answer provided below has been developed in a clear step by step manner Ste... View the full answer