XL.DateToTicks function

XL.DateToTicks function – Date and time function type – returns the number of ticks that represent the specified date and time.

A single tick represents one hundred nanoseconds or one ten-millionth of a second. There are 10,000 ticks in a millisecond and 10 million ticks in a second.

The value represents the number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001 in the Gregorian calendar.

Syntax

=XL.DateToTicks(date)

ArgumentDescription
date
[required]
An expression representing the date and time value

Any questions or suggestions?
How can we help?