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.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
Is it possible to determine the day of the week for a particular date?I have a range of time values, but when I try to sum them, the total is never greater than 24 hours?