Hi,
Having a difficult time working this, what i am trying to do is whenever there are a range of workdates i want to take the first date/time and last date/time and find the time elapsed between the two. So with the data below i basically want it to for each workdate give me the time elapsed between the first and last value. Is there an easy way to do this?
MSTdateTimeFormat | WorkDate |
8/26/2019 6:39 | 8/26/2019 |
8/26/2019 10:34 | 8/26/2019 |
8/26/2019 16:18 | 8/26/2019 |
8/27/2019 6:22 | 8/27/2019 |
8/27/2019 15:13 | 8/27/2019 |
8/27/2019 16:11 | 8/27/2019 |
Gelöst! Gehe zu Lösung.
Hi @krishnagandhi,
yes there its! You could use the Summarize Tool and a Formula Tool to achieve this and here is how:
What happens:
- First we convert the Date to actual DateTime and Date data type using two DateTime-Tools
- Select to remove the original column
- Summarize to Group by Date and get First and last of every Date
- Formula Tool in the end to calculate the difference:
You'll probably choose something else, but I went with seconds 😉
Workflow is attached. Let me know if this works for you 😃
Best
Alex