Log in
x
or
x
x
Register
x

or
0
0
0
s2sdefault

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


Unit Conversion: (Convert between multiple units, such as time, distance, bits & bytes, etc. )

With Kutools for Excel’s Unit Conversion utility, you can quickly convert between multiple units without any formulas.

doc convert time to seconds 11

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!



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:

doc convert time to seconds 1

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

Tips: to 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:

doc convert time to seconds 2

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.

Kutools for Excel : with more than 120 handy Excel add-ins, free to try with no limitation in 60 days

1. Select a range you want to work with.

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

doc convert time to seconds 3

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:

doc convert time to seconds 4

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

doc convert time to seconds 5

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:

doc convert time to seconds 6

Click here to know more information about Unit Conversion.

 Download and free trial Kutools for Excel Now !


Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


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.

doc convert time to seconds 7

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:( Free Download Kutools for Excel Now! )

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:

doc convert time to seconds 8

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

doc convert time to seconds 9

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:

doc convert time to seconds 10

Download and free trial Kutools for Excel Now !


Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


Relative article:

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


Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    Gautam · 8 months ago
    Can anyone help with the desired output:-

    Input Data- 2 days 2 hours 2 minutes 2 seconds

    Desired Output - 50:02:02
  • To post as a guest, your comment is unpublished.
    Sachin · 1 years ago
    How to convert DD:H:MM format in to Hours
    For Ex.03:01:10 convert to hours formats 36:10(h:mm)