A B D E F G Chapter 01 - Exercise 15 The China Wall Restaurant Payroll Register, January 7-11, 20-- Employee Hourly Regular Overtime Gross Rate Hours Hours Earnings Hill, Jill $13.50 40 8 Lane, Joe $10.80 40 9 Miller, Bill $12.55 40 10 Chein, Han $12.15 40 12 Directions: a. Enter a formula in Cell E8 to calculate Gross Earnings for Jill Hill. Gross Earnings = Regular Earnings + Overtime Earnings Regular Earnings = Hourly Rate x Regular Hours Overtime Earnings = 1.5 x Hourly Rate x Overtime Hours b. Copy the formula into each of the other cells of Column E to calculate the Gross Earnings for each of the other employees. Format for Currency. Set Decimal places to 2. Set Currency symbol to $