Skip navigation

5 Replies Latest reply on Aug 25, 2014 7:17 AM by Kristian DiGaetano

I need to get the difference of two date-times within the same column

Kristian DiGaetano Aug 20, 2014 7:10 AM

I need to try and get the time difference that it takes to promote/demote an item in our SCM process. Currently the data given includes only one date associated with a dimension. Look below. I don't believe that it can be done, but I like to be proven wrong (and have been multiple times by the intelligent people on this forum...please help. Workbook attached.

Harvest Activity.twbx 92.0 KB

1. Re: I need to get the difference of two date-times within the same column

Shawn Wallwork Aug 22, 2014 1:17 PM (in response to Kristian DiGaetano)

Kristian, your workbook is password protected. You'll need to extract the data and repost the workbook.

--Shawn
Like Show 0 Likes(0)

Actions
2. Re: I need to get the difference of two date-times within the same column

Kristian DiGaetano Aug 25, 2014 6:29 AM (in response to Kristian DiGaetano)
Please try this.

Harvest Activity.twbx 89.1 KB
Like Show 0 Likes(0)

Actions
3. Re: I need to get the difference of two date-times within the same column

Kristian DiGaetano Aug 25, 2014 6:48 AM (in response to Kristian DiGaetano)

It was figured out by Ryan Stryker. Thank you for trying to help.
Like Show 0 Likes(0)

Actions
4. Re: I need to get the difference of two date-times within the same column

Shawn Wallwork Aug 25, 2014 7:13 AM (in response to Kristian DiGaetano)

Please post the solution workbook. Thanks.

--Shawn
Like Show 0 Likes(0)

Actions
5. Re: I need to get the difference of two date-times within the same column

Kristian DiGaetano Aug 25, 2014 7:17 AM (in response to Kristian DiGaetano)

This is the basis for solving the issue. We used the following calc.

ABS(DATEDIFF('hour',ATTR([Exec DateTime]),LOOKUP(ATTR([Exec DateTime]),-1)))
Like Show 0 Likes(0)

Actions

Go to original post

More Like This