Nevron Vision for SharePoint Documentation
Pivot Engine / Functions / Time Span Functions
In This Topic
    Time Span Functions
    In This Topic
    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