加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 大数据 > 正文

将秒转换成“天 时:分:秒“格式(vb实现)

发布时间:2020-12-16 23:22:46 所属栏目:大数据 来源:网络整理
导读:' 将秒转换成“天 时:分:秒“格式 Private Function Duration(ByVal ss As Long) As String Dim mi As Long: mi = 60 Dim hh As Long: hh = mi * 60 Dim dd As Long: dd = hh * 24 Dim day As Long: day = ss / dd Dim hour_ As Long: hour_ = (ss - day *

' 将秒转换成“天 时:分:秒“格式 Private Function Duration(ByVal ss As Long) As String Dim mi As Long: mi = 60 Dim hh As Long: hh = mi * 60 Dim dd As Long: dd = hh * 24 Dim day As Long: day = ss / dd Dim hour_ As Long: hour_ = (ss - day * dd) / hh Dim minute_ As Long: minute_ = (ss - day * dd - hour_ * hh) / mi Dim second_ As Long: second_ = (ss - day * dd - hour_ * hh - minute_ * mi) Dim strDay As String: strDay = IIf(day < 10,"0" & day,"" & day) Dim strHour As String: strHour = IIf(hour_ < 10,"0" & hour_,"" & hour_) Dim strMinute As String: strMinute = IIf(minute_ < 10,"0" & minute_,"" & minute_) Dim strSecond As String: strSecond = IIf(second_ < 10,"0" & second_,"" & second_) Duration = strDay & " " & strHour & ":" & strMinute & ":" & strSecond End Function

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读