X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fsearch%2Ftimeworked.html;fp=httemplate%2Fsearch%2Ftimeworked.html;h=e810822d7af5bf3dc46480039bc2ed5b9f983b2f;hp=d07cd4f591b7d8f82f3d15547bdf7ab9ec2df042;hb=bd9ef4c4ca8644f99c1fcc595212f6a5c6787fc5;hpb=1551c7d41cea8bfa58ea1d3fb489cfb54823e5d8

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
 ";