SQL/time.sql at master · ngc2419/SQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23


===============================================================================================
Function FormatTimeSpan(TS as TimeSpan) as String
Dim DT as new DateTime(TS.Ticks)
Return DT.ToString("HH:mm:ss:fff")
End Function

=IIF(IsNothing(Timespan.FromTicks(avg(Fields!Average_Handle_Time_Per_Call.Value)))
, Nothing
, Code.FormatTimeSpan(Timespan.FromTicks(avg(Fields!Average_Handle_Time_Per_Call.Value))))

=IIF(IsNothing(Timespan.FromTicks(sum(Fields!Total_Time_on_Calls.Value)))
, Nothing
, Code.FormatTimeSpan(Timespan.FromTicks(sum(Fields!Total_Time_on_Calls.Value))))

===============================================================================================
-- convert seconds to hhmmss
=Format(DateAdd("s", Fields!TotalTime.Value, "00:00:00"), "HH:mm:ss"),

===============================================================================================