-
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
-
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
-
-
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>
-
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"))