Crystal Report Function for converting Seconds to Timespan format.
Posted
by arakkots
on Stack Overflow
See other posts from Stack Overflow
or by arakkots
Published on 2010-03-08T15:04:46Z
Indexed on
2010/03/08
15:06 UTC
Read the original article
Hit count: 273
I have a crystal report where it shows the Agent's activities throughout the day with a pie chart. In the details section it is displaying:
- Activity [string]
- StartedAt [DateTime]
- EndedAt [DateTime]
- Duration [The difference between EndedAt and StartedAt in seconds - Integer]
Report data is GroupedBy Activity and summarized by Duration.
Currently Duration is shown in seconds but I need to format it 02h:30m:22s:15ms. For that I wrote a custom function in Crystal Report in the Formula Workshop editor as follows, but it looks like the syntax is not right (Error message on keyword Long: "A variable type (for example, 'String') is missing."). Can someone help?
Function GetTimeSpanString(seconds as Long)
Dim ts As TimeSpan = TimeSpan.FromSeconds( seconds );
GetTimeSpan = string.Format("{0:D2}h:{1:D2}m:{2:D2}s:{3:D3}ms",
ts.Hours,
ts.Minutes,
ts.Seconds,
ts.Milliseconds)
End Function
© Stack Overflow or respective owner