calculating total time using datediff()

[reshmaarora22]

hi

i have i table called Description which has details about StartTime , EndTime and ScheduleDate of the various Transaction occuring daily.I want to fetch total time spend on a particular transaction which can occur on any day of week.Eg:

A transaction occured on 5th jan from 2pm to 3pm and
on 6th jan 1pm to 3pm
so total time spent is 1+2= 3 hrs.
Can this be done with a query ? or i hav to do some changes in my code.?



Regards

[bwestover]

hi

i have i table called Description which has details about StartTime , EndTime and ScheduleDate of the various Transaction occuring daily.I want to fetch total time spend on a particular transaction which can occur on any day of week.Eg:

A transaction occured on 5th jan from 2pm to 3pm and
on 6th jan 1pm to 3pm
so total time spent is 1+2= 3 hrs.
Can this be done with a query ? or i hav to do some changes in my code.?



Regards

This transaction is the same one over and over and you need a running total?

Select sum(Datediff(hour,StartTime, EndTime))
Where TransactionID = 12345

Or if you want to list the totals for all the transactions.

Select TransactionID, sum(Datediff(hour,StartTime, EndTime))
Group By TransactionID

These will do it in hours, if you want more precision you use minutes or seconds and then do the math to get your display right.