Calculate The Difference in Time between two Events in same Group

• tinoco43

  SSC Veteran

  Points: 287

  More actions

  May 1, 2017 at 4:11 pm

  #330010

  I have a report that is grouped by account number and each account having two events in the details, I want to calculate the difference in time between event 1 and event 2. 

  I have the Start and End times of these events and I know that it should be:
  event1.EndTime minus even2.StartTime = my difference in minutes. 

  But I am not sure how to build this into my ssrs report .  Any suggestions?