Date time Difference from a range of times

Question

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?

MSTdateTimeFormatWorkDate8/26/2019 6:398/26/20198/26/2019 10:348/26/20198/26/2019 16:188/26/20198/27/2019 6:228/27/20198/27/2019 15:138/27/20198/27/2019 16:118/27/2019

jdunkerley79 · Accepted Answer

You can use a summarise tool to get the min and max date/time for each Workdate

Then you can use a formula tool to compute the difference in which ever unit you wish.

A quick sample is attached.

Hopefully enough to get you started