SSRS 2005 以 HH:MM:SS 格式显示持续时间超过 24 小时的秒数

Question

首先感谢大家的帮助！！！

我想做的就是获取一些在 SSRS 2005 中工作的 VB.net 代码，将 123465 显示为 34:17:45。

这是我到目前为止所尝试过的：

Public Shared Function secondsToString(seconds As int64) As String
Dim myTS As New TimeSpan(seconds * 10000000)
If seconds > 0 then
  Return String.Format("{0:00}:{1:00}:{2:00}",myTS.Hours, myTS.Minutes, myTS.Seconds)
Else
  Return ""
End if
End Function

您能提供的任何帮助都会很棒！

再次感谢！

Answer 1

Public Shared Function secondsToString(seconds As int64) As String
Dim myTS as new TimeSpan(seconds * 10000000)
If seconds > 0 then
  Return String.Format("{0:HH\\:mm\\:ss}",seconds)
Else
  Return ""
End if
End Function

Answer 2

Public Shared Function secondsToString(seconds As int64) As String
   Dim myTS As New TimeSpan(seconds * 10000000)
   If seconds > 0 then
     Return String.Format("{0:00}:{1:00}",myTS.TotalHours, myTS.Minutes)
   Else
     Return ""
   End if
End Function