Time Format – Show Minutes & Seconds – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to show the time in minutes and seconds in Excel and Google Sheets

time format show minutes seconds Main Func

Show Time in Minutes and Seconds in Excel

To format a range of cells that are displayed in time format to show just minutes and seconds, you need to create a custom format for the range.

  1. Highlight the cells you wish to format eg: C3:C12.
  2. In the Ribbon, select Home > Number and then click on the little arrow on the right-hand side of the number group.

FORMAT-01

  1. The Format Cells dialog box will be shown.

FORMAT 02

  1. Click on Custom at the bottom of the list, and then type mm:ss into the custom format text box.

FORMAT 03

  1. Click OK.

TEXT Function in Excel

You can also format a range of cells to just show the minutes and seconds using the TEXT Function.

=TEXT(B3,"mm:ss")

TEXT

  1. Click in C3.
  2. Type the formula shown above.
  3. Copy the formula down to C10.

 

Show Time in Minutes and Seconds in Google Sheets

Showing minutes and seconds from a time value in Google sheets is similar to Excel.

 

  1. Highlight the range you wish to format eg: C3:C8.
  2. From the menu, select Format > Number > More Formats > More date and time formats.

Google Format 01

  1. Delete the 3 formats shown by clicking on each format and selecting Delete.

Google Format 02

  1. Scroll down the list and find a format with minutes and seconds.

Google Format 03

  1. Click on that format to add it to the bar at the top of the custom box.

Google Format 04

  1. Delete the Hour format from the custom format.

Google Format 05

  1. Click Apply to apply the formatting to your worksheet.

 

TEXT Function in Google Sheets

The Text function in Google sheets works the same as it does in Excel.

=TEXT(B3,"mm:ss")

Google Text