DATEDIFF function

For a moment, let's assume that the Tripduration was not provided and we need to calculate it. Using the starting and ending time, we can create a calculated field that holds the duration. In fact, let's create the duration in the measurement of minutes rather than seconds or hours! Use the built-in function DATEDIFF() to allow Tableau to compare the two dates stamps.

If you lost progress, load the workbook 1_3_datediff.twbx from the Workbooks folder on the Desktop.