Excel Formulas to Find the Time Difference in Hours as Decimal Value!!

By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. Today, I will introduce some easy tricks to find the time difference in hours as a decimal value in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Generic Formula:

If you want to find the time difference in hours as a decimal value, you can use the below formula.

=MOD(end-start,1)*24

Syntax Explanations:

MOD – In Excel, the MOD function helps to return the remainder of the two numbers after division.

Start – It specifies the starting time on your worksheet.

End – It represents the ending time on your worksheet.

Multiplication (*) – In this symbol will multiply any two values or numbers.

Minus Operator (-) – This symbol will help to subtract any two values.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

First, we will enter the input times in Column B and Column C.

Here, we have to calculate the time difference between these two times as decimal hours.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Wrap-Up:

Hope you like this article on how to calculate the time difference between two times and return the decimal hours in Excel. Please feel free to state your query or feedback for the above article.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Read Ahead:

Excel Formulas to Calculate the Sum of Race Time Splits ~ Quick Tricks!!

Excel Formulas to Find the Next Working Day ~ Quick Solution!!

How to Increment a Value by Row or Column in Excel Office 365?

Excel Formulas to Calculate the Sum by Fiscal Year ~ Quick Method!!