We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

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.

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.

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

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.

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)

Get started with Causal today.

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

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