可以把“h”换成“n”,这样求出来的是分。
dim num as long
dim t as string
num=DateDiff("n",CDate([进库日期] & " " & [进库时间]),CDate([出库日期] & " " & [出库时间]))
t=t=int(num/60) & ":" & num mod 60作者: hsn2914 时间: 2010-6-8 17:15
谢谢todaynew帮助!我的用另一个方法,供大家参考:
Public Function HoursAndMinutes(interval As Variant) As String
'***********************************************************************
' Function HoursAndMinutes(interval As Variant) As String
' Returns time interval formatted as a hours:minutes string
'***********************************************************************
Dim totalminutes As Long, totalseconds As Long
Dim hours As Long, minutes As Long, seconds As Long
If IsNull(interval) = True Then Exit Function
hours = Int(CSng(interval * 24))
totalminutes = Int(CSng(interval * 1440)) ' 1440 = 24 hrs * 60 mins
minutes = totalminutes Mod 60