Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
Conclusion
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.
523 Views
