Pinterest Pixel

Decimals to Time in Excel – A Step-by-step Guide

Imagine you are given task to convert decimals to time in Excel format for accurate payroll calculations.... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

Decimals to Time in Excel - A Step-by-step Guide | MyExcelOnline Decimals to Time in Excel - A Step-by-step Guide | MyExcelOnline

Imagine you are given task to convert decimals to time in Excel format for accurate payroll calculations. In this scenario, you receive time entries from employees in decimal minutes format, where each decimal represents the fraction of an hour spent working.

In this article, we’ll explore the process of converting decimals to time in Excel, providing step-by-step guidance to help you achieve accurate results –

Let us look at each of these steps in detail.

Download the Excel Workbook below to follow along and understand how to turn Decimals to Time in Excel –

download excel workbook DecimalstoTimeinExcel.xlsx

 

Understanding Decimal Time

Before looking into the Excel functions, it’s important to understand the concept of decimal time. In traditional time notation, an hour is divided into 60 minutes, and a minute is divided into 60 seconds. However, in decimal time, an hour is represented as 1, and fractions of an hour are expressed in decimals. For example, 30 minutes is represented as 0.5 (since 30 minutes is half of an hour).

See also  Best Excel Tips: Round to the Nearest Dollar Easily and Accurately

Scenario

Let’s explore the process of determining the hours worked by employees:

Decimals to Time in Excel

Our goal here is to convert these decimals to minutes (hh:mm) to streamline the payroll process. The time format is essential for accurate calculations and better representation of working hours.

We also have a tutorial on how to do the reverse, Convert Time to Decimal!

Solution

Go to cell C2 and enter =B2/24. This formula we are going to use divides the decimal value by 24 (since there are 24 hours in a day) and formats the result as hours and minutes.

Decimals to Time in Excel

Decimals to Time in Excel

As you can see, the formula has converted the time to Excel’s time format.

Drag the small box located at the bottom-right corner of cell C2 downward to automatically extend and apply the formula to the remaining hours.

Decimals to Time in Excel

 

Decimals to Time in Excel

Right-click the selected cells and go to Format Cells.

Decimals to Time in Excel

 

Go to Custom.

Decimals to Time in Excel

Delete the General and input h:mm.

See also  How to Calculate Percentage of Goal Calculation Formulas in Excel

Decimals to Time in Excel

Click OK.

Decimals to Time in Excel

As you can see the, the decimals have been converted to a more readable time format.

Sum the Hours

To sum the hours worked, go to D2, and enter =SUM(C2:C7).

Decimals to Time in Excel

Decimals to Time in Excel

Right-click on D2, and click on Format Cells.

Go to Custom. Put brackets around the letter [h]:mm.

Decimals to Time in Excel

Click OK.Decimals to Time in Excel

Conclusion
There you have it! Whether you’re working on timesheets, scheduling tasks, or analyzing time-based data, mastering this conversion process will enhance your Excel proficiency.

If you like this Excel tip, please share it
Decimals to Time in Excel - A Step-by-step Guide | MyExcelOnline Decimals to Time in Excel - A Step-by-step Guide | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...