第1个回答 2018-07-01
Sub SS()
Dim T As Date '存放停车时间
Dim D As Integer '存放停车单价
Dim MyP As Integer '存放应付停车费用
T = #2:25:38 AM# '给定一个停车时间
D = 10 '给定一个停车单价
MyP = ParkingFee(T, D)
Debug.Print MyP
End Sub
'自定义函数,根据停车时间和停车单价返回费用
Function ParkingFee(ByVal MyT As Date, ByVal MyD As Integer) As Integer
Dim HH As Integer
Dim MM As Integer
Dim SS As Integer
HH = Hour(MyT)
MM = Minute(MyT)
SS = Second(MyT)
If HH = 0 Then
ParkingFee = MyD
Else
If MM < 15 Then
ParkingFee = HH * MyD
Else
ParkingFee = (HH + 1) * MyD
End If
End If
End Function本回答被提问者采纳
第2个回答 2018-07-01
Function ParkingFee(h As Integer, m As Integer, s As Integer, p As Single) As Single
Dim t As Integer
t = 0
If 0 = h And (m > 0 Or s > 0) Then
t = 1
ElseIf h >= 1 Then
t = h
If m >= 15 Then
t = t + 1
End If
End If
ParkingFee = t * p
End Function