Calculate a Time Diff between records.

[menuch]

How would I calculate a time difference between records. I need to calculate the time between time2 of one record with time 1 of the next and so on. I am trying to figure out downtime between jobs. Time 1 is the start time and time2 is the end time of a particular job.

Veh# Shift Start
005 Tour 2 4:37:00PM
Job# Time1 Time2
180239 5:56 pm 7:22 pm
180241 7:41 pm 9:11 pm
180243 9:11 pm 10:23 pm
180244 10:24 pm 11:33 pm

any help would be appreciated.

Thanks,
Menuch

 

[IdoMillet]

Have a look at the Previous() function.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[menuch]

I tried that. But for the very first record in each group I want it to calculate between the Sgift start time and Time 1. It works for every group besides the very first one.

 

[GJParker]

Have a look ate the OnFirtsRecord Function or the RecordNumber function

HTH

Gary Parker
Systems Support Analyst
Manchester, England