converting minutes

[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.

 

[Ken Snell \(MVP\)]

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.

 

[Guest]

Create in the query a new field that returns minutes

NewFieldName: [FieldName] * 60

 

[ËÎСÀÖ]

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