5 Replies Latest reply on Nov 6, 2015 9:01 AM by Paul Mathewson

# Time difference on a set start/end time

So I'm looking to see how much time surgeons start early/go over their blocked out times.

Ex: If their block is 8 am to 3 pm and they have a procedure that finishes  at 7:45 am and then later in the day another one that finishes up  at 3:15 pm. I need to calculate the 15 minute difference from the start 0800 and the 15 minute difference on the end at 0300 so on that day they would be 30 minutes out of their utilized time.

• ###### 1. Re: Time difference on a set start/end time

Can you post up a sample data set included in a packaged workbook?  This will help answer the question in more detail.

• ###### 2. Re: Time difference on a set start/end time

Not sure how to do the packaged workbook but I've attached the excel of what the data looks like.

So the Column 'B' is the time we use for the instance. If it's after 0800 or 1500 then I need the minutes from each of those respectively.

• ###### 3. Re: Time difference on a set start/end time

Hi Ram,

I put together an example in Tableau for you.  It seems like you wanted both the end time and in time (from block time) to be compared to Column B or Discharge time.  It may make more sense to compare In to Patient In to In and Discharge to Out, but that is your call.  I've changed the data a bit to split the block time in to a start and end time.  That way we can use it in a calculated field.  Currently, this workbook analyzes the difference in minutes but that could be changed.  This could also be done strictly in Tableau but would take many calcs to get the date parsing right from block time.

Hope this provides some ideas for you.

Paul

interworks

• ###### 4. Re: Time difference on a set start/end time

Paul,

I tried to open that workbook and apparently I'm not on the most updated version of Tableau. I'm on the desktop version 9.0, any idea how I can see this file?

• ###### 5. Re: Time difference on a set start/end time

Hi Ram,

I can tell you what's going on in case that's not an option.

1. Created two new columns in the excel data source:  Start Time and End Time
• These are date time values for when the block begins (8:00) and when it ends (15:00).  These also have the data value from from column B
2. Once we have these new columns, we can do a DATEDIFF calculation to find the difference between column B and the start and end times.  I did mine in minutes.
3. Then visualize the two new calculations that find the time difference from start and end time to Column B.  As I mentioned above, You may want to use Column A to compare to start time and Column B to compare to end time.  Though that's a business question.

All the Best,

Paul