<< Click to Display Table of Contents >> MILLISECONDS (milliseconds)

Syntax:

MILLISECONDS(Time)

Description:

This returns the milliseconds of a time value.

Compatibility notes:

This function does not exist in Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced with their current result as a fixed value.

Example:

MILLISECONDS("12:34:56.555") returns 555

MILLISECONDS("09/25/2018 12:34:56.555") returns 555

If cell A1 contains a date with the time 12:34:56,555, then MILLISECONDS(A1) returns 555

See also:

HOUR, MINUTE, SECOND