Display time in minutes and seconds format with Format Cells function. You can format the HH:MM:SS cells to minutes and seconds only by customizing a format in the Format Cells dialog box. Please do as follows. 1. Select and right click the cells with time you want to display in minutes and seconds, and then click Format Cells in the right-clicking menu. See screenshot:How do you add one hour to time in Excel?
2. Then right click to select Format Cells from the context menu. And in the Format Cells dialog, under Number tab, select Custom from the Category list, then type m/d/yyyy hh:mm:ss into the Type textbox. See screenshots: 3. Click OK. Then you can see each date and time cell is added one hour.How do you calculate minutes in Excel?
Select the Cell B1. Enter the formula = (A1-A2)*1440. In the formula you have to minus the 1st date from the to 2nd date. That is, you have to minus the small date from the large date. To convert the time into minutes you have to multiply by 1440. (24 hours * 60 minutes = 1440). Press enter on the keyboard.