![]() You can easily deduct 30 minutes from the converted minutes. Then, on the second cell, convert the entered hours to minutes, i.e., hours *1440. On your Excel worksheet, enter the hours to be converted to minutes in the first column.Ģ. Here are the formulae to convert hours to minutes.ġ. ![]() Given time in hours, you can convert it to minutes and then subtract minutes (30 minutes). Choose the time format you want to apply to your cells from the type section.Ĭonverting Hours to Minutes, and then subtracting 30 minutes From the list displayed, select the time button.ĥ. On the dialogue box, choose the number tab. On the side-view menu, choose the format cells option.Ĥ. Then, right-click on the highlighted cells.ģ. Highlight the cells you want to change the format.Ģ. To change the time format, these steps are followed:ġ. Finally, click the enter button, and the new time will be displayed on the selected cell. ![]() Then, enter the subtraction formulae (=A1-A2).Ĥ. Select another blank cell where the results will be stored. In this case, you'll use the time format also, i.e., 00:30:00.ģ. ![]() On the second cell, enter the minutes to be subtracted (30 minutes). Enter your initial time in time format (HH:MM: SEC).Ģ. Then use the subtraction operation to compute the difference.ġ. In this format, you must enter the time the cells use the time format.įor example, You can enter 11:56:00 in the first cell and then enter the minutes to be subtracted (30 minutes) in the second cell. This is one of the simplest methods of subtracting 30 minutes from a given time. Converting Hours to Minutes, and then subtracting 30 minutes. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |