Excel Formulas to Calculate the Time Duration With Number of Days!!

Have you ever tried to calculate the total time duration with the number of days in Excel? This article will show you some methods to achieve it. Let’s jump 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:

Use the below formula to calculate the time duration with the number of days, hours, and minutes.

=days+TIME(hh,mm,0)

Syntax Explanations:

TIME – In Excel, the TIME function helps to create time on your worksheet.
Days – It represents the number of days.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Plus operator (+) – This symbol is used to add the values.

Example:

Let’s consider the below example image.

First, we will enter the input values in Column B , Column C , and Column D.
Here, we have to calculate the total time duration with the number of days.

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.

Wind-Up:

From this article, you can get some clarification on how to calculate the total time duration based on the given days, hours, minutes in Excel. Hope you like it. If you have any questions , feel free to comment.

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