batch file converting to time 2

[ziggs]

I have a batch file that produces a line of date/time that looks like this:

Sat 08/30/2008 17:30:51.09
Sat 08/30/2008 17:39:28.25
Sat 08/30/2008 17:57:39.57

In CR8, I want to show how many seconds (rounded off to one second) it took for the next line. Thus, the report would look like:

Sat 08/30/2008 17:30:21.09
Sat 08/30/2008 17:39:28.25 9 Seconds
Sat 08/30/2008 17:57:39.57 11 Seconds

 

[IanWaterman]

Use a formula

If not onfirstrecord then
datediff("s", datefield, previous(datefield))
else
0

Ian

 

[lbass]

A little correction since you are sorting in ascending datetime order:

datediff("s", previous(datefield), datefield)

-LB