ExcelBanter - multiply Hrs:Mins by £Hourly Pay

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - multiply Hrs:Mins by £Hourly Pay (https://www.excelbanter.com/excel-worksheet-functions/192964-re-multiply-hrs-mins-%C2%A3hourly-pay.html)

Mike H

multiply Hrs:Mins by £Hourly Pay

Hi,

Multiply by 24

=((B1-A1)*24)*C1

Where

A1= Start time
B1 = Finish thime
C1= Hourly rate

Mike

"Ric Parris" wrote:

Hi
I'm trying to set up a wages check sheet and having trouble coming up with
the formula to multiply the hours worked with the hourly rate

All times are GMT +1. The time now is 03:03 AM.