Hi there, i'm stuck with this. the open time and close time is stored in single table. i want the duration of each and every a day they have multiple records. can any one please let me know how to calculate. i'm attaching the worksheet as well.

Hello Surya, Here is the workbook with the solution. Please mark the answer as correct if it helps you.

wrong calculation going on, it taking the whole duration if you look from 14-07-2017 11:02:54 to 14:07-2017 17:5:48 which was 6hour 47min and 54 sec but i want to calculate the difference between first open record i.e,14-07-2017 11:02:54 and close record 14-07-2017 11:04:07 duration,second record of open with second record of close like that. can you please help. Thankyou.

Skip to main content

2019年8月6日 7:16

How can i get duration of each and every record of open time and the close time

Hi there,

i'm stuck with this. the open time and close time is stored in single table. i want the duration of each and every record.in a day they have multiple records. can any one please let me know how to calculate. i'm attaching the worksheet as well.

Scada Report.twbx

6 件の回答

Tableau Community Forums Member (Inactive) (Salesforce)
2019年8月6日 10:53
Hello Surya,
Here is the workbook with the solution. Please mark the answer as correct if it helps you.