How To Display Time In Minutes Format Only In Excel?

Excel is a sophisticated tool with numerous formatting options for customising how data is displayed. Excel has a number of choices for displaying time, including displaying time in hours, minutes, seconds, or a combination of these units. However, in other cases, you may want to display time only in minutes, ignoring the hours and seconds. In this tutorial, we will go through step−by−step steps for creating this time format in Excel. Whether you're working on a time−sensitive project, analysing data, or simply trying to communicate time information more effectively, this course will provide you with the knowledge and skills you need to succeed.

We'll go over a variety of cases, including formatting existing time data in minutes only and formatting time computations to present results in the preferred manner. By the end of this course, you'll have a firm grasp on the procedure and be able to apply it to your own Excel spreadsheets. So, let's get started and learn how to display time in minutes just in Excel!

Display Time In Minutes Format Only

Here we will format the range of cells to complete the task. So let us see a simple process to know how you can display time in minutes format only in Excel.

Step 1

Consider an Excel sheet where you have a list of times similar to the below image.

First, select the range of cells, then right−click and click on format cells.

Select cells > Right click > Format cells.

Step 2

Then click on custom, enter the type as [m]:ss and click OK to complete the task.

Custom > Type > Ok.


In this tutorial, we have used a simple example to demonstrate how you can display time in minutes format only in Excel to highlight a particular set of data.

Updated on: 12-Jul-2023


Kickstart Your Career

Get certified by completing the course

Get Started