4 Replies Latest reply on Jun 12, 2018 8:34 PM by Vijay Kumar MV

Difference Calculation between times

elias.daniels.0 Jun 12, 2018 7:12 PM

Hi all,

A simple question.

How can I get the time difference in hours or minutes, for two different times.

For example:

Time 1

26/05/18

17:40

Time 2

27/05/18

02:30

Result should be: 8.83 Hrs or 530 mins

I have been trying to use timediff, but I'm struggling with negative results.

Also, can you please advise how to format the time to be in 24Hrs format.

Thanks in advance,

Elias

1. Re: Difference Calculation between times

Vijay Kumar MV Jun 12, 2018 7:29 PM (in response to elias.daniels.0)

Hi Elias,

Did you try the calculation below:

DATEDIFF('minute',[Date1],[Date2])

I am able to get 530 minutes. Please find the workbook attached.

Regards,
Vijay Kumar
Like Show 0 Likes(0)

Actions
2. Re: Difference Calculation between times

Vijay Kumar MV Jun 12, 2018 7:30 PM (in response to Vijay Kumar MV)
Attached the workbook here.

TimeDiff.twbx 7.9 KB
Like Show 0 Likes(0)

Actions
3. Re: Difference Calculation between times

elias.daniels.0 Jun 12, 2018 8:02 PM (in response to Vijay Kumar MV)

Hi Vijay,

Thanks for your answer.

Unfortunately I cannot open your workbook, cuz I've an older version. I
will update soon.

Yes I did use that formula, the same way. What I think is the problem, is
that I just inserted times, no dates. Therefore, I guess tableau does not
know they are different days after midnight.

Are you using dates in your workbook?

Cheers,

Elias

Sent from my Samsung Galaxy Note 4

On Wed, 13 Jun 2018, 12:45 Vijay Kumar MV <tableaucommunity@tableau.com>
Like Show 0 Likes(0)

Actions
4. Re: Difference Calculation between times

Vijay Kumar MV Jun 12, 2018 8:34 PM (in response to elias.daniels.0)

Yes, I am using Dates.

Another way to look at it:
DATEDIFF('minute',DATETIME("May 26, 2018 5:40:00 PM"),DATETIME("May 27, 2018 2:30:00 AM"))
Like Show 0 Likes(0)

Actions

Tableau Community Forums