Time To Decimal & Decimal To Time Calculator

  1. Use HH Text Box to Enter Hours.
  2. Use MM Text Box to Enter Minutes.
  3. Use SS Text Box to Enter Seconds.
  4. See the results in Decimal Time Text Box.
  5. You can revrse the process by entering decimal time and getting results in standard time format(Decimal To Time).
  6. Use Clear Button to clear All the Time entered.
  7. Use Print Button To Print the Results.
  8. Use Email Box if you want to recieve the Results at your Email ID.

HH : MM : SS
Decimal Time

Clear

Print

Email


How to Use Time to Decimal Calculator?

Playing around with time values, like adding them, subtracting them is not as simple as it looks, especially, when we are dealing with regular time in AM/PM format. We have to take care of many details like hours and minutes and day and night. Such calculations become more confusing when you have a load of calculating salaries through AM/PM time card of your several employees. A single mistake may add an extra burden to the business's finance.

However, if we convert time values into typical numeric values, it becomes a lot easier to process theses time values to deduce the correct salary. To make this conversion easier and quicker, our programmers have gone through days of research, coding and testing to bring you Time to Decimal Calculator.

Time to Decimal Hours Calculator can convert your 24-Hours format time having hours, minutes and seconds into decimal hours instantly.

Follow the methods below to use our Time to Decimal Hours Calculator efficiently:

Method 1 – Converting 24 Hours format time to Decimal Hours

time to decimal calculator

Enter your Time in 24 Hours format, in the HH, MM and SS textboxes, where HH stands for Hours, MM stands for Minutes, and SS stands for Seconds.

Once, you have entered your values; Decimal Time will automatically be calculated and displayed on the textbox next to Decimal Time label.

Method 2 – Converting Decimal To Time (Military 24 Hours Format)

decimal to time calculator

Enter your Time in Decimal Hours format in the textbox next to Decimal Time Label.

Once, you have entered your Decimal Hours, the time in Military Time (24 Hours format) will automatically be calculated and displayed on the HH, MM and SS textboxes (As shown in the image above).

Method 3 – Converting Regular time (AM/PM format) into Decimal Hours

The two methods mentioned above were to convert Military Time (24 Hours format) into Decimal Hours or vice versa. However, as we all know, that we usually record time in regular time format, also known as AM/PM format. Therefore, we need any method to convert our AM/PM format into Decimal Hours Instantly.

If this is something you are looking for, then don’t worry! We have a solution for you. Follow the steps below and get your work done instantly:

Step 1:

Regular time to military

First Thing you need to do is to convert your Regular Time (AM/PM) format into Military Time using our Military Time Converter.

You need to enter your Hours in HH textbox, Minutes in MM textbox and Select your time period; AM or PM, from the dropdown menu, as shown in the image above.

Once you have entered the values, Military Time will automatically be displayed on the textbox beside Military Time label.

Step 2:

military time to decimal

Once you are done with the conversion of Regular Time into Military Time, you can come back to our Time to Decimal Hours Converter, and follow the instructions below:

  • Enter your Time in 24 Hours format (Military Time), in the HH, MM and SS textboxes, where HH stands for Hours, MM stands for Minutes, and SS stands for Seconds.
  • Once, you have entered your Values. The Decimal Time will automatically be calculated and displayed on the textbox next to Decimal Time

Note: If you want to convert our Decimal Hours into Regular Time (AM/PM format), you can reverse the method as mentioned earlier.

Bonus:

print-time-to-decimal

Once you are done with your conversion, you can click on the "Clear" button to reset the calculator. You can also print the sheet by using a "Print" button. Moreover, you have an option to email the calculations to anyone by entering His/her email address and clicking on "Email" Button.

Convert Time to Decimal Formula:

Below are the basic formulas to convert Time into Decimal Hours, Decimal Minutes and Decimal Seconds respectively:

Convert Time to Decimal Formula

Time to Decimal Chart

All the Military Time and their equivalent decimal hours, decimal minutes and decimal seconds are written in the Minutes to Decimal Hours table (time clock conversion for payroll table) below:

TimeHoursMinutesSeconds
00:00:00000
00:05:000.0833335300
00:10:000.16666710600
00:15:000.2515900
00:20:000.333333201200
00:25:000.416667251500
00:30:000.5301800
00:35:000.583333352100
00:40:000.666667402400
00:45:000.75452700
00:50:000.833333503000
00:55:000.916667553300
01:00:001603600
01:05:001.083333653900
01:10:001.166667704200
01:15:001.25754500
01:20:001.333333804800
01:25:001.416667855100
01:30:001.5905400
01:35:001.583333955700
01:40:001.6666671006000
01:45:001.751056300
01:50:001.8333331106600
01:55:001.9166671156900
02:00:0021207200
02:05:002.0833331257500
02:10:002.1666671307800
02:15:002.251358100
02:20:002.3333331408400
02:25:002.4166671458700
02:30:002.51509000
02:35:002.5833331559300
02:40:002.6666671609600
02:45:002.751659900
02:50:002.83333317010200
02:55:002.91666717510500
03:00:00318010800
03:05:003.08333318511100
03:10:003.16666719011400
03:15:003.2519511700
03:20:003.33333320012000
03:25:003.41666720512300
03:30:003.521012600
03:35:003.58333321512900
03:40:003.66666722013200
03:45:003.7522513500
03:50:003.83333323013800
03:55:003.91666723514100
04:00:00424014400
04:05:004.08333324514700
04:10:004.16666725015000
04:15:004.2525515300
04:20:004.33333326015600
04:25:004.41666726515900
04:30:004.527016200
04:35:004.58333327516500
04:40:004.66666728016800
04:45:004.7528517100
04:50:004.83333329017400
04:55:004.91666729517700
05:00:00530018000
05:05:005.08333330518300
05:10:005.16666731018600
05:15:005.2531518900
05:20:005.33333332019200
05:25:005.41666732519500
05:30:005.533019800
05:35:005.58333333520100
05:40:005.66666734020400
05:45:005.7534520700
05:50:005.83333335021000
05:55:005.91666735521300
06:00:00636021600
06:05:006.08333336521900
06:10:006.16666737022200
06:15:006.2537522500
06:20:006.33333338022800
06:25:006.41666738523100
06:30:006.539023400
06:35:006.58333339523700
06:40:006.66666740024000
06:45:006.7540524300
06:50:006.83333341024600
06:55:006.91666741524900
07:00:00742025200
07:05:007.08333342525500
07:10:007.16666743025800
07:15:007.2543526100
07:20:007.33333344026400
07:25:007.41666744526700
07:30:007.545027000
07:35:007.58333345527300
07:40:007.66666746027600
07:45:007.7546527900
07:50:007.83333347028200
07:55:007.91666747528500
08:00:00848028800
08:05:008.08333348529100
08:10:008.16666749029400
08:15:008.2549529700
08:20:008.33333350030000
08:25:008.41666750530300
08:30:008.551030600
08:35:008.58333351530900
08:40:008.66666752031200
08:45:008.7552531500
08:50:008.83333353031800
08:55:008.91666753532100
09:00:00954032400
09:05:009.08333354532700
09:10:009.16666755033000
09:15:009.2555533300
09:20:009.33333356033600
09:25:009.41666756533900
09:30:009.557034200
09:35:009.58333357534500
09:40:009.66666758034800
09:45:009.7558535100
09:50:009.83333359035400
09:55:009.91666759535700
10:00:001060036000
10:05:0010.08333360536300
10:10:0010.16666761036600
10:15:0010.2561536900
10:20:0010.33333362037200
10:25:0010.41666762537500
10:30:0010.563037800
10:35:0010.58333363538100
10:40:0010.66666764038400
10:45:0010.7564538700
10:50:0010.83333365039000
10:55:0010.91666765539300
11:00:001166039600
11:05:0011.08333366539900
11:10:0011.16666767040200
11:15:0011.2567540500
11:20:0011.33333368040800
11:25:0011.41666768541100
11:30:0011.569041400
11:35:0011.58333369541700
11:40:0011.66666770042000
11:45:0011.7570542300
11:50:0011.83333371042600
11:55:0011.91666771542900
TimeHoursMinutesSeconds
12:00:001272043200
12:05:0012.08333372543500
12:10:0012.16666773043800
12:15:0012.2573544100
12:20:0012.33333374044400
12:25:0012.41666774544700
12:30:0012.575045000
12:35:0012.58333375545300
12:40:0012.66666776045600
12:45:0012.7576545900
12:50:0012.83333377046200
12:55:0012.91666777546500
13:00:001378046800
13:05:0013.08333378547100
13:10:0013.16666779047400
13:15:0013.2579547700
13:20:0013.33333380048000
13:25:0013.41666780548300
13:30:0013.581048600
13:35:0013.58333381548900
13:40:0013.66666782049200
13:45:0013.7582549500
13:50:0013.83333383049800
13:55:0013.91666783550100
14:00:001484050400
14:05:0014.08333384550700
14:10:0014.16666785051000
14:15:0014.2585551300
14:20:0014.33333386051600
14:25:0014.41666786551900
14:30:0014.587052200
14:35:0014.58333387552500
14:40:0014.66666788052800
14:45:0014.7588553100
14:50:0014.83333389053400
14:55:0014.91666789553700
15:00:001590054000
15:05:0015.08333390554300
15:10:0015.16666791054600
15:15:0015.2591554900
15:20:0015.33333392055200
15:25:0015.41666792555500
15:30:0015.593055800
15:35:0015.58333393556100
15:40:0015.66666794056400
15:45:0015.7594556700
15:50:0015.83333395057000
15:55:0015.91666795557300
16:00:001696057600
16:05:0016.08333396557900
16:10:0016.16666797058200
16:15:0016.2597558500
16:20:0016.33333398058800
16:25:0016.41666798559100
16:30:0016.599059400
16:35:0016.58333399559700
16:40:0016.666667100060000
16:45:0016.75100560300
16:50:0016.833333101060600
16:55:0016.916667101560900
17:00:0017102061200
17:05:0017.083333102561500
17:10:0017.166667103061800
17:15:0017.25103562100
17:20:0017.333333104062400
17:25:0017.416667104562700
17:30:0017.5105063000
17:35:0017.583333105563300
17:40:0017.666667106063600
17:45:0017.75106563900
17:50:0017.833333107064200
17:55:0017.916667107564500
18:00:0018108064800
18:05:0018.083333108565100
18:10:0018.166667109065400
18:15:0018.25109565700
18:20:0018.333333110066000
18:25:0018.416667110566300
18:30:0018.5111066600
18:35:0018.583333111566900
18:40:0018.666667112067200
18:45:0018.75112567500
18:50:0018.833333113067800
18:55:0018.916667113568100
19:00:0019114068400
19:05:0019.083333114568700
19:10:0019.166667115069000
19:15:0019.25115569300
19:20:0019.333333116069600
19:25:0019.416667116569900
19:30:0019.5117070200
19:35:0019.583333117570500
19:40:0019.666667118070800
19:45:0019.75118571100
19:50:0019.833333119071400
19:55:0019.916667119571700
20:00:0020120072000
20:05:0020.083333120572300
20:10:0020.166667121072600
20:15:0020.25121572900
20:20:0020.333333122073200
20:25:0020.416667122573500
20:30:0020.5123073800
20:35:0020.583333123574100
20:40:0020.666667124074400
20:45:0020.75124574700
20:50:0020.833333125075000
20:55:0020.916667125575300
21:00:0021126075600
21:05:0021.083333126575900
21:10:0021.166667127076200
21:15:0021.25127576500
21:20:0021.333333128076800
21:25:0021.416667128577100
21:30:0021.5129077400
21:35:0021.583333129577700
21:40:0021.666667130078000
21:45:0021.75130578300
21:50:0021.833333131078600
21:55:0021.916667131578900
22:00:0022132079200
22:05:0022.083333132579500
22:10:0022.166667133079800
22:15:0022.25133580100
22:20:0022.333333134080400
22:25:0022.416667134580700
22:30:0022.5135081000
22:35:0022.583333135581300
22:40:0022.666667136081600
22:45:0022.75136581900
22:50:0022.833333137082200
22:55:0022.916667137582500
23:00:0023138082800
23:05:0023.083333138583100
23:10:0023.166667139083400
23:15:0023.25139583700
23:20:0023.333333140084000
23:25:0023.416667140584300
23:30:0023.5141084600
23:35:0023.583333141584900
23:40:0023.666667142085200
23:45:0023.75142585500
23:50:0023.833333143085800
23:55:0023.916667143586100

FAQs

Answer: For converting times into decimals, there are three basic methods, and they are as follow:

Method 1 – Converting Regular Time into Decimal Hours manually:

To better understand the technique, we will be using the time value of 3:30:40 PM as an example.

Step 1: Convert Regular Time into Military Time:

To convert your regular time into decimal hours, we to need to convert our regular time into military time:

As our example time is in PM and is higher than 1:00 PM, we will be adding 12 Hours in our original example time: 3 + 12 = 15 Hours.

Here, Minutes and Seconds will remain the same.

Now our example Military Time is: 15:30:40

Step 2: Convert Military Time into Decimal Hours:

The basic formula for Decimal Hours is:

Decimal Hours = Hours +  Minutes x (1/60) + Seconds x (1/3600)

Putting our Example Military Time into the Formula: 15 + 30 x (1/60) + 40 x 1/3600

Decimal Hours = 15 + 0.50 + 0.01

Decimal Hours = 15.51 

Method 2 – Converting Military Time into Decimal Hours manually:

To better understand the method, we will be using the time value of 18:40:50 as an example.

Using Step 2 of Method 1 of this question, the decimal Hours for 18:40:50 would be:

Decimal Hours = 18 + 40 x (1/60) + 50 x (1/3600)

Decimal Hours = 18 + 0.66 + 0.01

Decimal Hours = 18.67

Method 3 – Converting Regular or Military Time into Decimal Hours using our Converters:

Don't have time to follow the methods mentioned above for conversion? Then you can use our:

  • Time to Decimal Hours Converter to convert Military (24-Hours format) into Decimal Hours
  • Military Time Converter along with Time to Decimal Hours Converter to convert Regular Time into Decimal Hours.

Note: Above mentioned points are discussed in detail under the heading "How to Use Time to Decimal Calculator?" located above.

Answer: You can convert Hours and Minutes into Decimal Hours as well as Decimal Minutes by following the methods below:

Note: We will be using 15:30 as our Example Time.

Method 1 – Converting time into Decimal Hours:

Here Hours would remain same, and we will only convert Minutes into Decimals Hours and add it back into Original Hours as shown below:

Decimal Hours = Hours + (Minutes / 60)

Decimal Hours = 15 + (30/60)

Decimal Hours = 15 + 0.5

Decimal Hours = 15.5 

Method 2 – Converting time into Decimal Minutes:

Here Minutes would remain same, and we will convert Hours into Decimal Minutes and add them back into original Minutes:

Decimal Minutes = (Hours x 60) + Minutes

Decimal Minutes = (15 x 60) + 30

Decimal Minutes = 930

Bonus Method – Converting time into Decimal Seconds:

Example Time = 15:30:40

Here Seconds would remain Same, and we will convert Hours and Minutes into Decimal Seconds and Add with original Seconds:

Decimal Seconds = (Hours x 3600) + (Minutes x 60) + Seconds

Decimal Seconds = (15 x 3600) + (30 x 60) + 40

Decimal Seconds = 54000 + 1800 + 40

Decimal Seconds = 55840

Note: You can get instant and accurate results for your time to decimal conversions using our Time to Decimal Hours Converter.

Answer:

15 Minutes as a Decimal Hours = 15/60 = 0.25 Decimal Hours

15 Minutes as a Decimal Minutes = 15/1 = 15 Decimal Minutes

15 Minutes as a Decimal Seconds = 15*60 = 900 Decimal Seconds

Note: You can get instant and accurate results for your time to decimal conversions using our Time to Decimal Hours Converter.

Answer:

  • 1 hour and 45 minutes as a Decimal hour:

Decimal Hours = 1 + (45/60)

Decimal Hours = 1.75

  • 1 hour and 45 minutes as a Decimal Minutes:

Decimal Minutes = 1*60 + 45

Decimal Minutes = 105

  • 1 hour and 45 minutes as a Decimal Seconds:

Decimal Seconds = 1*3600 + 45*60 + 0

Decimal Seconds = 3600 + 2700 + 0

Decimal Seconds = 6300

Note: You can get instant and accurate results for your time to decimal conversions using our Time to Decimal Hours Converter.

Answer:

  • 1 hour and 50 minutes as a Decimal hour:

Decimal Hours = 1 + (50/60)

Decimal Hours = 1.83

  • 1 hour and 50 minutes as a Decimal Minutes:

Decimal Minutes = 1*60 + 50

Decimal Minutes = 110

  • 1 hour and 50 minutes as a Decimal Seconds:

Decimal Seconds = 1*3600 + 50*60 + 0

Decimal Seconds = 3600 + 3000 + 0

Decimal Seconds = 6600

Note: You can get instant and accurate results for your time to decimal conversions using our Time to Decimal Hours Converter.

Answer:

  • 15 minutes as a Decimal hour:

Decimal Hours = 0 + (15/60)

Decimal Hours = 0.25

  • 15 minutes as a Decimal Minutes:

Decimal Minutes = 0*60 + 15

Decimal Minutes = 15

  • 15 minutes as a Decimal Seconds:

Decimal Seconds = 0*3600 + 15*60 + 0

Decimal Seconds = 0 + 900 + 0

Decimal Seconds = 900

Note: You can get instant and accurate results for your time to decimal conversions using our Time to Decimal Hours Converter.

Answer: There are two basic methods to convert time to decimal in Ms Excel. They are as follow:

Method 1 – Using Arithmetic Function

Using Arithmetic Function for time to decimal

We will use an example of times as shown in the image below to explain you the method in the best way:

  1. We made table having columns and rows as shown in the image above.
  2. We made sure that the time column’s values are in Time format. (You can change the format using Number format dropdown menu at Home Tab).
  3. Then we entered the formula =(A2*24) to calculate decimal hours instantly.

Note: Here, "24" is the total number of hours in a day. You can change it to "1440" as the total number of minutes in a day for Decimal minutes. Moreover, you can also use "86400" as total seconds in a day for Decimal Seconds.

 Method 2 – Using Convert Function

We used the same example above to convert the time 2 of it using the Convert function as shown in the image above:

=CONVERT(A3, "day", "hr")

Note: You can change the "hr" segment to "yr", "day", "mn" and "sec" for decimal years, days, minutes and seconds respectively.

Method 3 – Using Hours, Minutes and Seconds Function

Carrying on with the example used in the above two methods, we changed the formula to Hours, Minutes and Seconds Formula to convert Time 3 (As shown in the image).

Decimal Hours:

=HOUR(A4) + MINUTE(A4)/60 + SECOND(A4)/3600

Note: You can alter the formula as stated below for Decimal Minutes and Decimal Seconds:

Decimal Minutes:

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

Decimal Seconds:

=HOUR(A4)*3600 + MINUTE(A4)*60 + SECOND(A4)

Suggestion: Why confusing yourself with all these tricky formulas? Simply enter your time on our Hours to Decimal Converter for instant conversion without getting into any hassles. 

Answer: Method to convert time into decimals is almost the same as in Ms Excel. Therefore, you can refer to FAQs – Question # 7 for your answer.