So how was it? Did you learn something new? Was it helpful? Share your questions and thoughts in the comments section.
Here I tried to explain how time and date are treated in Excel and how to do multiplication of time in excel. This will work in all versions of Microsoft Excel as it is simple math. In cell D2 write this formula and copy it in cells below: = C2 *24* B2 Now we can multiply it with C2 to get the correct value.
This tutorial will demonstrate how to sum values within multiple cells. When we multiply cell B2 with 24, we get 44 as the whole number. One of the most basic question to start learning Microsoft Excel is to how to add cells. So to get the hours as a number, we need to multiply the cell with 24 first. So each value in B column is equal to “value/24” Well, when a cell is formatted as date and time, 1 translates to 24 in that cell. When you try to directly multiply cells in excel you will give an answer like this.įor Raju it is 189.3333. In this way, it is possible to carry out the multiplication operation for a cell, row or column. In column D we want the net payable amount for that employee. Multiplication in excel is performed by entering the comparison operator equal to (), followed by the first number, the asterisk (), and the second number.
For example, you want to multiply 2 and 6 in the cell, then type 26 in the cell and press Enter. Now I want you to calculate the net payable amount of each entry as shown in the below image.ī has the time they worked for in HH:MM:SS format.Ĭ contains pay per hour. Answer (1 of 12): The quick and easy way of multiplying two values in a single-cell is by using a simple formula. So let’s say, you have time and per hour pay data in excel. Since it is easier to show than to explain it, let’s start with an example.
Hey there! You are trying to multiply time with the whole number in Excel but not getting what you want, right? This is because date and time are treated differently in Excel. Type the numbers you want to multiply, separated by an asterisk sign.