Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The Difference in Time between two Events in same Group

Status
Not open for further replies.

Petilucas

MIS
May 1, 2017
2
US
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?

Capture_gnwaok.jpg
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top