Sep 16 2021 10:09 AM
Does anyone know how to create a simple formula where I can multiply the number of hours worked by the standard rate of pay per hour to calculate the total money
Sep 16 2021 10:37 AM
@MsCherie Suppose the standard rate is in A1 and the hours are in column B1 and down, you could use in C1:
=$A$1*B1
and copy it down if needed.
Sep 16 2021 11:20 AM
I tried this and I'm going to see if I can drop it to you so you can see how it looks it should be $2,081.25 so I am doing something wrong.
Sep 16 2021 11:54 AM - edited Sep 16 2021 11:57 AM
Solution@MsCherie You need to multiply the duration (83:15) by 24 to get the numerical value of hours, i.e. 83.25. multiply by 25 ( the hourly rate) and you'll get 2081.25. Make sure you format H27 as "General".
Sep 16 2021 02:39 PM
Sep 16 2021 11:54 AM - edited Sep 16 2021 11:57 AM
Solution@MsCherie You need to multiply the duration (83:15) by 24 to get the numerical value of hours, i.e. 83.25. multiply by 25 ( the hourly rate) and you'll get 2081.25. Make sure you format H27 as "General".