diff options
| -rw-r--r-- | httemplate/search/timeworked.html | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/httemplate/search/timeworked.html b/httemplate/search/timeworked.html index d07cd4f59..e810822d7 100644 --- a/httemplate/search/timeworked.html +++ b/httemplate/search/timeworked.html @@ -45,7 +45,9 @@ my @groupby = (); my $transactiontime = " CASE Transactions.Type WHEN 'Set' - THEN (TO_NUMBER(NewValue,'999999')-TO_NUMBER(OldValue, '999999')) * 60 + THEN ( CASE WHEN NewValue = '' THEN 0 ELSE TO_NUMBER(NewValue,'999999') END + -TO_NUMBER(OldValue, '999999') + ) * 60 ELSE TimeTaken*60 END "; |