This @Formula can be very helpful in views if you want to display e.g. the processing time of documents…
Just replace the field names “DateTimeEnd” and “DateTimeStart” with your own date values or field names
_diff := (DateTimeEnd - DateTimeStart); _diff := @Integer(_diff); _hrs :=@Integer(_diff / 3600); _minutes := @Integer(_diff/60) - (_hrs*60); _minutes := @text(_minutes); _minutes := @if( @Length(_minutes) = 1; "0" + _minutes; _minutes); @Text(_hrs) + ":" + _minutes
This can look in a view like this:
By the way: archiving time of 24 minutes per documents might be a bit long, but the archive process does several things: renaming attachments, access to another DB with ODBC, PDF Converting, etc.