Google Sheets

PDURATION: Google Sheets Formulae Explained

How do you use PDURATION in Google Sheets?

The PDURATION function in Google Sheets calculates the duration of a given period of time. To use the function, you need to input the start date and end date of the period you want to calculate the duration for. The function will then return the number of days, hours, minutes, and seconds between the two dates. This can be useful for calculating deadlines, project timelines, or any other duration-based calculations.

What is the syntax of PDURATION in Google Sheets?

The syntax of PDURATION in Google Sheets is as follows: PDURATION(start_time, end_time, units) The function takes the start time, end time, and units as inputs and calculates the duration of time in the units specified.

What is an example of how to use PDURATION in Google Sheets?

The PDURATION function in Google Sheets calculates the number of days, hours, minutes, and seconds between two dates. For example, the following formula returns the number of days between "1/1/2018" and "1/7/2018":

=PDURATION("1/1/2018","1/7/2018")

The following formula returns the number of hours between "1/1/2018" and "1/7/2018":

=PDURATION("1/1/2018","1/7/2018")/24

The following formula returns the number of minutes between "1/1/2018" and "1/7/2018":

=PDURATION("1/1/2018","1/7/2018")/60

The following formula returns the number of seconds between "1/1/2018" and "1/7/2018":

=PDURATION("1/1/2018","1/7/2018")/3600

When should you not use PDURATION in Google Sheets?

There are a few occasions when you should not use the PDURATION function in Google Sheets. One such instance is when you are trying to calculate the number of days between two dates. In this case, you should use the DATEDIF function. Additionally, you should not use the PDURATION function to calculate the number of days between two dates if the dates are in different years. In this case, you should use the YEARFRAC function.

What are some similar formulae to PDURATION in Google Sheets?

The following are some similar formulae to PDURATION in Google Sheets:

-HOUR(TODAY()-DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())))

-DAY(TODAY())

-WEEKDAY(TODAY())

-WEEKDAY(DATE(YEAR(DATE),MONTH(DATE),DAY))

-TODAY()

-NOW()

-DATE(YEAR(DATE),MONTH(DATE),DAY)

-YEAR(DATE)

-MONTH(DATE)

-DAY(DATE)

Move beyond 

Google Sheets

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.