title: Converting total time in integer into HH:MM format in crystal report
body: <p>I am using below given formula to change 3.50 hours to 03:30(HH:MM) format in crystal report but it showing 04:30(1 hr added automatically)</p>
  
  <pre><code>numbervar totalHours:=ToNumber({Table.ExtraHoursOn1});
  numbervar totalminutes:=ToNumber({Table.ExtraHoursOn1})*60 mod 60;
  ToText(totalHours,0)+':'+
  ToText(totalminutes,'00')
  </code></pre>
  
  <p>I don't know where i am getting wrong.</p>