View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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