I took a quick look at the data,
and just wanted to see if there was an excel format
that would work straight up with Tableau.
I transposed the data into:
RowID Date Start1 Finish1 Start2 Finish2 1 10/25/2017 14:00 15:00 2 10/26/2017 9:00 11:15 3 11/1/2017 7:15 11:15 14:45 15:30
Then I pulled this into Tableau and created the start times as:
and likewise for the other start and finish times.
Each set had it's own difference:
and then summed those up:
It seems likely that these manipulations can be done in Prep.
Please see workbook attached in the Forum Thread.
Thanks for the information. I did not know about makedate function you have suggested. I will play with this and see what I can come up with.