evaluating time from 2 records on a single table

[g8orade]

I am trying to evaluate time from a record on a table where the start_datetime and end_datetime ( note: start and end dates is equal in this record) is between the start_datetime and end_datetime of another record. In the evaluation process I will need elapsed seconds from the record that has both the same start and end time until the endtime of the record that it falls in.
Thanks

 

[Ina]

I don't fully understand your requirements but wouldn't sorting first by 'another record' and then by start or end times help any?

 

[swilliams]

Are you doing this calculation in Crystal??
Do you know the two records of interest and can you get these onto the same record by way of a query (eg StartDateTime1,EndDateTime1,StartDateTime2,EndDateTime2??

If the answer is yes to both of the above, whenever I have done this before in Crystal, I have had to convert the time to seconds first, work out the difference / sum /... of the seconds (easy) and then convert back to a time.