I need help to create formula to multiply hours worked times hourly rate to get pay amount.
S sirrafs Sep 14, 2006 #1 I need help to create formula to multiply hours worked times hourly rate to get pay amount.
B Biff Sep 14, 2006 #2 If the hours worked are formatted as TIME: =hours_worked*24*hourly_rate A1 = hours in TIME format = 40:00 A2 = hourly rate = $45.00 =A1*24*A2 Biff
If the hours worked are formatted as TIME: =hours_worked*24*hourly_rate A1 = hours in TIME format = 40:00 A2 = hourly rate = $45.00 =A1*24*A2 Biff
