MILLISECONDS (milliseconds)

<< Click to Display Table of Contents >>

MILLISECONDS (milliseconds)

Syntax:

MILLISECONDS(Time)

Description:

Returns the milliseconds of a time value.

Compatibility notes:

This function is not supported by Microsoft Excel. If you save a document in Excel format, all calculations using this function will be replaced by their last result as a fixed value.

Example:

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

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

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

See also:

HOUR, MINUTE, SECOND