Resolve time difference in hours and minutes of two date/time values

Resolve time difference in hours and minutes of two date/time values

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:

Calculating Time Difference of 2 date/time values

Calculating Time Difference of 2 date/time values

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.

Leave a Reply

comment-avatar

*