Microsoft Excel Question: Download Questions PDF
I have a worksheet that shows total hours and minutes worked, along with the hourly pay rate. When I multiply these vales, I do not get the result I am looking for. What is wrong?
Answer:
You need to multiply the result by 24, for the number of hours in a day. If cell A1 contains the number of hours worked (for example, 16:45, for 16 hours and 45 minutes) and cell B1 has the hourly rate, the formula below will calculate the total wages:
=A1*B1*24
Make sure the cell that contains the formula is formatted as a number, not a time.
=A1*B1*24
Make sure the cell that contains the formula is formatted as a number, not a time.
Download MS Excel Interview Questions And Answers
PDF