Home » Internet » How To Convert Time Duration To Minutes And Seconds In Excel

Internet

How To Convert Time Duration To Minutes And Seconds In Excel

Geeksdigit Team

May 28, 2026

0 Views

SaveSavedRemoved 0

Microsoft Excel is one of the most powerful spreadsheet applications used for calculations, reporting, data analysis, and time management. Many users work with time durations in Excel while tracking attendance, video lengths, task completion times, workout sessions, production hours, call durations, or project timelines. However, Excel stores time values differently than regular numbers, which can sometimes make converting durations into minutes and seconds confusing for beginners.

For example, a time value such as:

• 01:30:45

actually represents:

• 1 hour
• 30 minutes
• 45 seconds

Users often need to convert these durations into:

• Total minutes
• Total seconds
• Minutes and seconds only
• Decimal minutes
• Readable MM:SS format

Fortunately, Excel provides multiple methods for converting time durations using formulas, formatting tools, arithmetic calculations, and built-in functions. In this detailed guide, you will learn how to convert time duration to minutes and seconds in Excel using up to 10 easy methods with step-by-step explanations.

Understanding How Excel Stores Time

Before converting time durations, it is important to understand how Excel handles time internally.

Excel stores time as fractions of a day:

Because of this system, converting time requires multiplying the values properly.

For example:

• Multiply by 1440 for total minutes
• Multiply by 86400 for total seconds

Understanding this makes time conversion much easier.

Method 1: Convert Time Duration To Total Minutes

This is the most commonly used method.

Suppose cell A1 contains:

01:30:00

Formula

=A1*1440

Explanation

• Excel stores one day as 1440 minutes
• Multiplying the time value by 1440 converts it into total minutes

Result

90

This method is ideal for attendance sheets, task tracking, and duration calculations.

Method 2: Convert Time Duration To Total Seconds

You can also convert time into seconds.

Formula

=A1*86400

Explanation

• One day contains 86400 seconds
• Multiplying converts the duration into total seconds

Example

If A1 contains:

00:05:30

The result becomes:

330

This method is useful for sports timing, audio editing, video processing, and scientific calculations.

Method 3: Display Time In Minutes And Seconds Format

Sometimes users only want to display durations as MM:SS.

Steps

• Select the cells
• Press:
  • Ctrl + 1
• Open:
  • Format Cells
• Choose:
  • Custom
• Type:

mm:ss

Example

A duration of:

00:02:45

will display as:

02:45

This method changes appearance only and does not alter the actual value.

Method 4: Convert Hours Into Minutes Automatically

If your duration contains hours, you can extract only minutes.

Formula

=HOUR(A1)*60+MINUTE(A1)

Example

For:

01:45:00

Result:

105

This converts:

• 1 hour = 60 minutes
• plus 45 minutes

This method ignores seconds.

Method 5: Convert Time Into Minutes Including Seconds

To include seconds as decimal minutes:

Formula

=HOUR(A1)*60+MINUTE(A1)+SECOND(A1)/60

Example

For:

01:30:30

Result:

90.5

This is useful for precise time tracking.

Method 6: Use TEXT Function For Minutes And Seconds

The TEXT function can convert time into readable text format.

Formula

=TEXT(A1,"mm:ss")

Result

30:45

This method is helpful when creating reports or exporting formatted time values.

However, TEXT results are not numeric values.

Method 7: Convert Decimal Minutes Back To Time

Sometimes users already have decimal minutes and want proper time formatting.

Formula

=A1/1440

Then format the cell as:

mm:ss

Example

If A1 contains:

90

The result becomes:

01:30:00

This method reverses the conversion process.

Method 8: Use INT Function To Separate Minutes And Seconds

You can extract minutes and seconds separately.

Minutes Formula

=INT(A1*1440)

Seconds Formula

=MOD(A1*86400,60)

Example

For:

00:05:45

Results:

• Minutes = 5
• Seconds = 45

This method is useful in custom reports and dashboards.

Method 9: Convert Duration Using Power Query

Power Query provides advanced data transformation features.

Steps

• Select your data
• Open:
  • Data tab
• Click:
  • From Table/Range
• In Power Query:
  • Select the time column
• Add a custom column

Formula For Minutes

Duration.TotalMinutes([Time])

Formula For Seconds

Duration.TotalSeconds([Time])

Power Query is useful for large datasets and automation.

Method 10: Use VBA To Convert Time Automatically

Advanced users can automate conversions using VBA macros.

VBA Example

Function TimeToMinutes(T As Date)
TimeToMinutes = T * 1440
End Function

Steps

• Press:
  • Alt + F11
• Insert a module
• Paste the code
• Save the workbook

Then use:

=TimeToMinutes(A1)

This is useful for repetitive calculations in large Excel projects.

Difference Between Time Formatting And Conversion

Many beginners confuse formatting with actual conversion.

Formatting

Changes only how data appears.

Example:

mm:ss

Conversion

Changes the actual numeric value.

Example:

=A1*1440

Understanding this difference prevents calculation errors.

Common Time Conversion Mistakes

Users often face issues because Excel handles time differently.

Common Mistakes Include

• Forgetting to multiply by 1440
• Using incorrect cell formatting
• Treating text as time values
• Mixing decimal and time formats
• Ignoring seconds in calculations

Proper formatting solves most problems.

How To Convert Text Time Into Real Time

Sometimes imported data appears as text.

Formula

=TIMEVALUE(A1)

This converts text into usable Excel time values.

After conversion, apply any time formulas normally.

Best Uses For Time Conversion In Excel

Time conversions are widely used in many industries.

Common Examples

• Employee attendance tracking
• Video editing durations
• Call center reports
• Sports timing
• Workout tracking
• Manufacturing production logs
• Transportation schedules
• Billing systems

Excel simplifies all these calculations efficiently.

Tips For Working With Time In Excel

To avoid errors:

• Always use proper time formatting
• Use brackets for large durations:

[h]:mm:ss

• Keep raw data separate from formulas
• Test formulas with sample values
• Use decimal conversions carefully

These practices improve spreadsheet accuracy.

FAQs

How do I convert time into total minutes in Excel?

Use:

=A1*1440

How do I convert time into seconds?

Use:

=A1*86400

Why does Excel show decimals instead of time?

Because Excel stores time as fractions of a day.

What format displays minutes and seconds only?

Use custom formatting:

mm:ss

How do I handle durations longer than 24 hours?

Use custom formatting:

[h]:mm:ss

This prevents Excel from resetting hours after 24.

Final Thoughts

Converting time duration to minutes and seconds in Microsoft Excel is an important skill for managing schedules, reports, attendance systems, production data, and many other time-based calculations. Although Excel stores time internally as fractions of a day, using the correct formulas makes conversions very simple and accurate.

Whether you need total minutes, total seconds, MM:SS formatting, decimal minutes, or advanced automated calculations, Excel provides several powerful methods to handle time efficiently. Basic formulas like multiplying by 1440 or 86400 are usually enough for most users, while Power Query and VBA offer advanced automation for larger projects.

Once you understand how Excel handles time values, working with durations becomes much easier, faster, and more professional.