Note: The other languages of the website are Google-translated. Back to English

## How to convert between hours, minutes, seconds or days in Excel?

How do you figure out how many minutes are in the one and a half day, or how many hours are in the five million seconds? This article will show you some easy way to deal with it.

Convert between hour, minute, second or day with functions

Convert between hour, minute, second or day with Kutools for Excel

Convert hh:mm:ss time format to minutes, seconds or hours with formulas

Convert hh:mm:ss time format to minutes, seconds or hours with Kutools for Excel

1. Convert time between hour, minute, second, or day with conversion factor

As we known, 1 hour = 60 minutes = 3600 seconds =1/24 day. So we can convert the time measurement with multiplying these factors.

Convert between hours to seconds:

For example, to convert the hours to seconds, please enter the formula =A2*3600, and then drag the fill handle down to the cells to get the results you need, see screenshot:

If you want to convert seconds to hours, just apply this formula: =A2/3600.

Tips: Convert between hours and minutes, days:

 Convert hours to minutes: =A2*60 Convert minutes to hours: =A2/60 Convert hours to days: =A2/24 Convert days to hours: =A2*24

2. Convert time between hour, minute, second, or day with Convert function

It is hard to remember the conversion factors? You can use the Convert function to convert tween hour, minutes, seconds or days too.

To convert hours to seconds:

Please type this formula =CONVERT(A2,"hr","sec") to easily convert cells from hours to seconds at once. See screenshot:

If you want to convert seconds to hours, just apply this formula: =CONVERT(A2,"sec","hr").

Tips: Just replace the unit name in the formula, you can easily convert between these time measurements.

 measurement using in formula Year "yr" Day "day" Hour "hr" Minute "mn" Second "sec"

Do not need to remember neither the conversion factor nor the function, Kutools for Excel's Unit Conversion tool can help you easily deal with it.

 : with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

1. Select a range you want to work with.

2. Click the Kutools > Content > Unit Conversion. See screenshot:

3. Specify the Time unit in the drop-down box of Unit, and then select source unit in the left box, converted unit in the right box, and you will see the result in the Preview box. See screenshot:

4. Click Ok or Apply. The time between hours and minutes are converted as following screenshot shown:

Note: If you want to keep the source unit in the cells and show results in the comment, you can check Add results as comment. See screenshot:

Sometimes you may get a time with hour, minutes, and seconds together, and now you can use the following formulas to convert it to minutes, seconds or hours.

Convert hh:mm:ss time format to hours:

Please apply this formula to convert the hh:mm:ss time format to hours: =HOUR(A2) + MINUTE(A2)/60 + SECOND(A2)/3600,and drag the fill handle to the cells that you want to contain this formula.

Tips:

To convert hh:mm:ss time format to minutes: =((HOUR(A2)*60)+MINUTE(A2)+(SECOND(A2)/60));

To convert hh:mm:ss time format to seconds: =HOUR(A2)*3600 + MINUTE(A2)*60 + SECOND(A2).

Are you tired with the formulas, so ,here, I can introduce you a handy and easy tool-Kutools for Excel, with its Convert Time feature, you can quickly finish this job without any formulas.

After installing Kutools for Excel, please do as follows:()

1. Select the time cells that you want to convert.

2. Click Kutools > Content > Convert Time, then choose Time to Hours / Time to Minutes / Time to Seconds as you need, see screenshot:

3. And the selected time cells have been converted into the desired hours, minutes or seconds you need, see screenshot:

Tips: If you want the converted result located in another location, you can go the Convert Time dialog by clicking Kutools > Content > Convert Time, in the Convert Time dialog box, choose the convert type you need, and then check Save to another location checkbox, and click a cell where you want to put the result, see screenshot:

#### Relative article:

How to convert between kb and mb, gb, tb and vice versa?

### The Best Office Productivity Tools

#### Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
• More than 300 powerful features. Supports Office / Excel 2007-2021 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

#### Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
How to convert DD:H:MM format in to Hours For Ex.03:01:10 convert to hours formats 36:10(h:mm)
This comment was minimized by the moderator on the site
Can anyone help with the desired output:- Input Data- 2 days 2 hours 2 minutes 2 seconds Desired Output - 50:02:02
This comment was minimized by the moderator on the site
In the example - Convert hh:mm:ss time format to hours:
Time is 24:12:09 converted to 0.2025 hours. This is not correct.

This comment was minimized by the moderator on the site
Hi, Joshi,Normally, in Excel the time 24:12:09 is recognized as 00:12:09 by default.
This comment was minimized by the moderator on the site
Hoe zet ik een tijd bijv 12:15u om naar getal 12,25 in excel?

Alvast bedankt!
This comment was minimized by the moderator on the site
Hi there,
You can simply multiply the time by 24.

Note that you should apply the general format on the cell (B2): Select B2, press Ctrl + 1, click General. Then click OK.

Amanda
This comment was minimized by the moderator on the site
if work start on 5-3-15 10:30 PM proposed work completed after 76478hr 45 minutes and daily working hrs are 6hrs how to calculate work completed time and date
This comment was minimized by the moderator on the site
Vraagje: Ik moet van 04:22 naar 00:04:22, welke formule kan ik gebruiken?
This comment was minimized by the moderator on the site
Hi there,

There is a workaround with Kutools:
1. Select 04:22 and then click To Actual) on Kutools tab.
2. On Kutools tab, in Editing group, select Text > Add Text. In the pop-up dialog, enter "0:" in the first textbox, and select Before first character.

3. Select the cell, press Ctrl + 1, and then click Time, and select a time format you want.

Now, the hour:munite is converted to minute:second.

Amanda
There are no comments posted here yet