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