Fractions of a second 1

[JohnWantsToKnow]

How can I get Crystal to display 10ths of a second? All time formats seem to be just to a whole number of seconds.
I'm trying to get crystal to show the length of time taken to produce a report and display the time taken in the report footer. Suggestions on the best method of doing this also appricated.
Using Ver8.5

 

[pgtek]

Hi

I don't think this possible

cheers

pgtek

 

[mbarron]

It is possible. I was a doubter until I tried it.

Here is the formula:

stringvar pt:= totext(printtime,"hh:mm:ss.ss"
stringvar dt:=totext(datatime,"hh:mm:ss.ss"
numbervar pth:=val(left(pt,2));
numbervar ptm:=val(mid(pt,4,2));
numbervar pts:=val(right(pt,5));
numbervar dth:=val(left(dt,2));
numbervar dtm:=val(mid(dt,4,2));
numbervar dts:=val(right(dt,5));
numbervar pttot:=3600*pth+60*ptm+pts;
numbervar dttot:=3600*dth+60*dtm+dts;
numbervar diff:=pttot-dttot;

numbervar hrs:=truncate(diff/3600);
numbervar min:=truncate((diff/3600-hrs)*60);
numbervar sec:=(((diff/3600-hrs)*60)-min)*60;

totext(hrs,"00&quot+ ":" + totext(min,"00&quot+ ":" + totext(sec,"00.00&quot

Mike

 

[Naith]

See Thread149-480703 for timing report processing.

 

[Naith]

Very sexy formula by the way Mike*.