折扣百分比
问题描述:
我需要在VB6代码做出折扣百分比
examble:
13 “天” - 10%= 11 “天”,16" 小时“48” 分钟”
我试试这个:
1 - 我天转换到m inutes
(13 * 24 * 60)= 18720
2.
Dim Result As Double
Result = ((100 - 10)/100) * 18720
Text3.Text = Result '"text3.text=16848"
现在如何可以格式化导致到DD HH NN? 感谢
答
像这样使用左/中/右关键字
Dim Result As Double
Dim Dayz, Hourz, MinuteZ As String
'
'Using your formula - which i have not checked
Result = ((100 - 10)/100) * 18720
'
'extract values
Dayz = Left(Result,2)
Hourz = Mid(Result, 3, 2)
Minutez = Right(Result, 2)
'concatenate
Text3.Text = (Dayz & " Days, " & Hourz & " Hours, " & Minutez & " Minutes.")
您还可以查看到FORMAT命令。
当然,重新转换回来。 –
如何在代码中重新转换@Giorgio_Brausi? –
结果/ 24/60,将返回11,7。 –