Nevron Vision for SharePoint Documentation
Time Span Functions
Syntax Description Example
TIMESPAN(sTimeSpan)

Returns a time span value from a string. See:
Time Span Try Parse on MSDN

TIMESPAN("10.20:30:40.50")

Returns: a time span with 10 days, 20 hours, 30 minutes, 40 seconds and 50 milliseconds

TOTALDAYS(tsTimeSpan) Returns the total days in a time span.

TOTALDAYS(TIMESPAN("10.20:30:40.50"))

Returns: 10.8546

TOTALHOURS(tsTimeSpan) Returns the total hours in a time span.

TOTALHOURS(TIMESPAN("10.20:30:40.50"))

Returns: 260.5112

TOTALMILLISECONDS(tsTimeSpan) Returns the total milliseconds in a time span.

TOTALMILLISECONDS(TIMESPAN("10.20:30:40.50"))

Returns: 937840500

TOTALMINUTES(tsTimeSpan) Returns the total minutes in a time span.

TOTALMINUTES(TIMESPAN("10.20:30:40.50"))

Returns: 15630.675

TOTALSECONDS(tsTimeSpan) Returns the total seconds in a time span.

TOTALSECONDS(TIMESPAN("10.20:30:40.50"))

Returns: 937840.5

 

 


©2016. Nevron Software LLC.

Send Feedback