How to Use Minutes & Seconds in Excel

Written by regina edwards
  • Share
  • Tweet
  • Share
  • Email

Excel calculates time in a specific calendar format, in order to convert days, hours, minutes and seconds. While cells in a spreadsheet can be formatted to reflect time and formulas will adjust to reflect the time format, data must be entered in hours:minutes:seconds (hh:mm:ss) for accurate calculations. Decimal values are converted according to the default start date for the application (e.g., 1/1/1904 12:00:00 AM). Be sure to format the cells before entering data and once time data and formulas are entered, descriptive charts and graphs can be generated to show time.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 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. 2

    Select "Cells" under "Format" in the top menu bar.

  3. 3

    Click the "Number" tab and select the "Custom" option from the list of categories on the left.

  4. 4

    Select "h:mm:ss" from the list of custom format or type "h:mm:ss" in the field under "Type."

  5. 5

    Click the "OK" button.

    Calculating Time

  1. 1

    Select the cell that will be used to calculate the total number of minutes and seconds entered.

  2. 2

    Type the following part of the formula, "=sum(" then select the first cell containing the data.

  3. 3

    Type "+" and then select the next cell containing the data. Repeat this step to select the cells to be calculated.

  4. 4

    Type ")" to complete the formula and press the "Enter" key.

Tips and warnings

  • If only minutes and seconds are tracked, enter the data as "00:mm:ss" where "mm" are minutes and "ss" are seconds because Excel converts time data to a calendar entry.
  • Consider displaying the time data on a chart, such as a bar chart or a pie chart to show time tracked: Select "Chart" under "Insert" and choose the type of chart. Click the "Preview" button to see how your data will appear. Continue through the chart wizard to type labels and choose options before clicking the "Finish" button.
  • Data previously entered in decimal format will convert to a date/time calculation. These values must be revised to the hh:mm:ss format.
  • Depending on your version of Excel, formatting cells in the custom type of "mm:ss" may yield inconsistent time conversions. Specifying "hh:mm:ss" yields consistent results across versions.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.