Formula questions for Excel re: multiplication

%3CLINGO-SUB%20id%3D%22lingo-sub-2757170%22%20slang%3D%22en-US%22%3EFormula%20questions%20for%20Excel%20re%3A%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2757170%22%20slang%3D%22en-US%22%3E%3CP%3EDoes%20anyone%20know%20how%20to%20create%20a%20simple%20formula%20where%20I%20can%20multiply%20the%20number%20of%20hours%20worked%20by%20the%20standard%20rate%20of%20pay%20per%20hour%20to%20calculate%20the%20total%20money%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2757170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2757319%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20questions%20for%20Excel%20re%3A%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2757319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1158049%22%20target%3D%22_blank%22%3E%40MsCherie%3C%2FA%3E%26nbsp%3BSuppose%20the%20standard%20rate%20is%20in%20A1%20and%20the%20hours%20are%20in%20column%20B1%20and%20down%2C%20you%20could%20use%20in%20C1%3A%3C%2FP%3E%3CP%3E%3D%24A%241*B1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20copy%20it%20down%20if%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2757528%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20questions%20for%20Excel%20re%3A%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2757528%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20this%20and%20I'm%20going%20to%20see%20if%20I%20can%20drop%20it%20to%20you%20so%20you%20can%20see%20how%20it%20looks%20it%20should%20be%20%242%2C081.25%20so%20I%20am%20doing%20something%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

4 Replies

@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.

 

@Riny_van_Eekelen 

 

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.

@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".

Thank you so much you are a life saver!!!