How to Use Minutes Seconds in Excel

1. Select and highlight the group of cells in your spreadsheet (such as a column or a row) where data will be entered as time in minutes and seconds.
2. Select 'Cells' under 'Format' in the top menu bar.
3. Click the 'Number' tab and select the 'Custom' option from the list of categories on the left.
4. Select 'h:mm:ss' from the list of custom format or type 'h:mm:ss' in the field under 'Type.'
5. Click the 'OK' button.
Calculating Time
6. Select the cell that will be used to calculate the total number of minutes and seconds entered.
7. Type the following part of the formula, '=sum(' then select the first cell containing the data.
8. Type ' ' and then select the next cell containing the data. Repeat this step to select the cells to be calculated.
9. Type ')' to complete the formula and press the 'Enter' key.