Microsoft Excel is one of the most optimal and indispensable calculation software on each person's computer. When using this software, users will be provided with many different types of functions, helping their calculations to be completed quickly and easily.
In the calculation process, sometimes we have to convert time into numbers, to do this in addition to performing the value conversion operation, we can also use some basic functions of Excel . Here we invite you to follow the article instructions on converting time to decimal numbers in Excel .
Download Microsoft Office 2016 Download Microsoft Office 2019
To be able to implement this method you first need to remember the unit of time and date conversion as:
Step 1: First, open up the value table you want to convert and click on any empty cell.
Step 2: Enter the formula: = + "Value to convert" * 24 , in the value cell in the hour column.
Step 3: To perform the remaining columns you also enter the following formula:
Step 4: Finally, after performing the formulas we will get a table of values as follows:
The CONVERT function is a function used to convert the values of measurement units. To convert time to decimal using this function, we perform the following steps:
Step 1 : Click on any empty cell in the value table.
Step 2: Enter the formula: = CONVERT ("Value", "from_unit", "to_unit") . Inside:
Units of conversion:
Note: In this article, From_unti will be "day" and convert time to number of hours / minutes / seconds, we replace the units in To_unti as "hr / mn / sec" respectively .
Step 3: Do the same with the remaining cells in each value column, finally we will get a table of values as below:
Above are some ways to convert time to decimal in Excel, we hope that these things will help you can easily and quickly complete your work.
In addition, you can also refer to some articles such as:
I wish you successful implementation!
Compare realistic side hustles for 2026 by startup cost, fees, flexibility, and income control, with current tax and scam guidance from official sources.
Upgrade your home office ergonomics with current OSHA and NIOSH guidance on chair fit, monitor height, laptop setup, lighting, and movement.
Learn why emotional intelligence matters in leadership, where it helps most, how to strengthen it, and how to tell whether your approach is working.
A practical roadmap for moving into tech without a degree: choose an accessible role, build job-ready skills, prove them with projects, and use hiring feedback to improve.
Build a credible LinkedIn personal brand in 2026 with current profile, content, newsletter, analytics, verification, and visibility guidance from LinkedIn.
Quiet quitting and quiet firing are catchy labels, not diagnoses. Learn what is verified, what depends on context, and what employees and managers can do next.
Fractional executives offer senior leadership without a full-time hire. Learn when the model works, what to ask, and the risks to manage.
Prepare a stronger Q4 raise request with current wage data, timing options, compensation tradeoffs, and scripts for yes, partial, or no outcomes.
Choose a high-income skill you can realistically start before 2026 ends, with current pay data, learning priorities, and a practical self-check.
Build a hybrid work schedule around tasks, team overlap, and measurable outcomes. See sample patterns, warning signs, and when to adjust your plan.
