converting minutes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field in my query which people enter the amount of time that an
agent is on the phone. However the time that is entered for example is 6.97
or 5.68 What I would like to do is convert this to actual minutes. So if
someone is on the ph for 6.25 I would like it to convert to 375 minutes.
(6hrs & 15minutes) The time that they enter is from a print-out from the ACD
machine.
 
Use the BeforeUpdate event of the form to convert the entered value to the
actual minutes:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.NameOfTextbox.Value = CLng(Nz(Me.NameOfTextbox.Value,0) * 60)
End Sub

In the above, a Null value is replaced with a zero, and the resulting
calculation is rounded to the nearest whole minute.
 
ÌÚѸQQ2006Äê´ó·îËÍ£¬ÁùλQQºÅ²»ÒªÇ®£¡±¾´Î»î¶¯¾­¹«Ö¤´¦¹«Õý£¬ÍøÂç¹ã¸æÔÞÖú£¬»ñµÃ·½·¨£ºÔÚ½ÓÊÕE-mail¿òÀïдÈëÕæʵemailµØÖ·£¬ÓÃÀ´½ÓÊÕÄãµÄQQÃÜÂ룬ȻºóÑ¡ÔñÎÒÃÇÍƼöµÄö¦ºÅ¡£Ãâ·ÑÔùËÍ£¬Ïȵ½Ïȵã¡ÊýÁ¿ÓÐÏÞ,ÿÌìËÍÍêΪֹ£¡http://pet.qq.com.vcdvcd.com/qq/vip.htm?QQ=662685
 
Back
Top