Calculate Duration Between Two Dates in Tableau in (HH:MM:SS)

#duration #tableaututorial #timecalculations

In this video tutorial, we show you how to calculate duration between two timestamps using the Modulo operator and display it in the standard HH:MM:SS format.

Download this exercise workbook:

***

Timestamps:
0:00 - Introduction
0:21 – Dataset
0:47 – Calculate the Difference in Seconds
1:36 – Calculate the Hours
2:15 – Leading 0s
3:08 – Calculate the Minutes & Seconds
4:32 – Concatenate the result
5:28 – Watch More Videos!

***

At DSCOVR Analytics we can help you unleash the power of your data with Tableau, a data visualization tool that has been recognized as the leading Analytics and Business Intelligence platform for 9 years in a row!

This channel’s mission is to help people just like you discover the beautiful world of data! We will guide you through every step to help you start solving problems like a real data scientist!

***

#dscovranalytics #datadriven #businessolutions

[georgedossantosaraujo]

Very good video, a question how do you show this duration longer than 24 hours?

[jeremiahakinlabi]

Very clear, thank you. The question is how you'd calculate total or average time now it's been changed to string

[UmeshYadav-lgcy]

Hello Thanks for this, How to calculate time duration between two dates excluding holiday and weekends. Please help

[carlagasparetto]

how can I calculate duration between days? In your example the duration is in the same day...