Formulas and Functions

DUR2MILLISECONDS
The DUR2MILLISECONDS function converts a duration value to a number of milliseconds.
DUR2MILLISECONDS(duration)
duration: The length of time (duration value) to be converted.
Examples |
---|
=DUR2MILLISECONDS("2w3d2h10m0s5ms") returns 1,476,600,005. =DUR2MILLISECONDS("10:0:13:00:05.500") returns 6,094,805,500. |