I have a sheet that calculates total number of hours worked in a week. I need to multiply this total by a rate of pay. Hours worked cells are formatted to time and Rate of pay cells are formatted to currency/number. When I try hrs worked cell X Rate of pay cell I get a silly answer. Can anyone help please?