• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Excel

How to convert decimal numbers to time in Excel

0 Comments

To convert a decimal number to time format (hours, minutes, seconds) in Excel, you should use basic functions to convert the values. You will separate the decimal number using the HOUR, MINUTE, and SECOND functions with the same method. Then, use the TIME function to combine them into a complete time. All operations are very simple and quick to perform. Read the article below to learn how to convert a decimal number to time format in Excel.

For example, we have decimal numbers that need to be converted into time as shown in the figure below. To convert decimal numbers to time, we need to separate each hour, minute, and second of that time by using the HOUR, MINUTE, SECOND functions. Then, use the TIME function to combine them into a complete time. Please follow the steps below.

How to convert decimal numbers to time in Excel

How to convert decimal numbers to time in Excel

Step 1: Separate the hour number

First, we will need to separate the hour number from the decimal number using the HOUR function. The structure of the HOUR function is as follows:

Function syntax: = HOUR(serial_number)

Where: serial_number: required argument, is the time containing the hour you want to extract.

Applying the above HOUR function structure, we have the formula in cell B2 as follows:

= HOUR(A2)

Copying the formula for the remaining cells in column B, we will quickly separate the hour number.

How to convert decimal numbers to time in Excel

How to convert decimal numbers to time in Excel

Step 2: Separate the minute number

Next, we will need to separate the minute number from the decimal number using the MINUTE function. The structure of the MINUTE function is as follows:

Function syntax: = MINUTE(serial_number)

Where: serial_number: required argument, is the time containing the minute you want to extract.

Applying the above MINUTE function structure, we have the formula in cell C2 as follows:

= MINUTE(A2)

Copying the formula for the remaining cells in column C, we will quickly separate the minute number.

How to convert decimal numbers to time in Excel

How to convert decimal numbers to time in Excel

Step 3: Separate the second number

Next, we will need to separate the second number from the decimal number using the SECOND function. The structure of the SECOND function is as follows:

Function syntax: = SECOND(serial_number)

Where: serial_number: required argument, is the time containing the second you want to extract.

Applying the above SECOND function structure, we have the formula in cell D2 as follows:

= SECOND(A2)

Copying the formula for the remaining cells in column D, we will quickly separate the second number.

How to convert decimal numbers to time in Excel

How to convert decimal numbers to time in Excel

Step 4: Combine the time

After we have separated the hour, minute, and second numbers, we combine them into a complete time using the TIME function. The structure of the TIME function is as follows:

Function syntax: = TIME(hour; minute; second)

Where:

Hour: required argument, is a number from 0 to 32767 that represents hours.
Minute: required argument, is a number from 0 to 32767 that represents minutes.
Second: required argument, is a number from 0 to 32767 that represents seconds.
Applying the above TIME function structure, we have the formula in cell E2 as follows:

= TIME(B2; C2; D2)

Copying the formula for the remaining cells in column E, we will obtain the complete time.

How to convert decimal numbers to time in Excel

How to convert decimal numbers to time in Excel

Thus, the above article has guided you on how to convert decimal numbers to time in Excel. We hope this article will be helpful to you in the future.

Rate this post
39
305 Views
Using the PROPER function to capitalize the first letter in ExcelPrevUsing the PROPER function to capitalize the first letter in ExcelFebruary 27, 2023
How to print even and odd pages easily in Microsoft ExcelFebruary 27, 2023How to print even and odd pages easily in Microsoft ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
  • Windows 11 Home Key Global 2021 Windows 11 Home Key Global 2021
    Rated 5.00 out of 5
    $6.00
  • Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global Windows Server 2022 Remote Desktop Services User Connections (50) Cal Key Global
    Rated 5.00 out of 5
    $22.00
  • AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years AVG Ultimate 2021 with Antivirus + Cleaner, Secure VPN 10 Devices 2 Years
    Rated 5.00 out of 5
    $47.00
Products
  • Microsoft Office Professional Plus 2010 retail Microsoft Office Professional Plus 2010 retail CD Key Global
    Rated 4.90 out of 5
    $11.00
  • Microsoft Visio Standard 2021 Key 1PC Microsoft Visio Standard 2021 Key 1PC $13.00
  • Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year Kaspersky Small Office Security 20 PCs + 20 Mobiles + 2 Servers 1 Year $284.73
  • Windows 10 Enterprise LTSC 2019 Key Global Windows 10 Enterprise LTSC 2019 Key Global
    Rated 4.83 out of 5
    $9.00
  • Windows Server 2025 Remote Desktop Services 50 Device Connections Windows Server 2025 Remote Desktop Services 50 Device Connections $25.00
  • Windows Server 2012 R2 Standard Key Global Windows Server 2012 R2 Standard Key Global
    Rated 4.78 out of 5
    $15.00
  • Microsoft Visio Professional 2010 Key 1PC Microsoft Visio Professional 2010 Key 1PC $9.00
  • Visio Professional 2024 Visio Professional 2024 $33.00
  • Microsoft SQL Server 2019 Enterprise Microsoft SQL Server 2019 Enterprise $39.00
  • Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account Microsoft Office Home And Business 2016 For Mac Key Global Bind Microsoft Account
    Rated 4.92 out of 5
    $15.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.