XL.DateToTicks function: convert date and time values to ticks
XL.DateToTicks function – Date and time function type – returns the number of ticks that represent the specified date and time.
For example, the date March 10, 2021 will be represented by 637509312000000000 ticks.
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.
Ticks represents the number of 100-nanosecond intervals that have elapsed since 12:00:00 midnight, January 1, 0001 in the Gregorian calendar.
Before you begin, add Functions to Excel
Functions are one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2019, 2016, 2013, 2010, desktop Office 365.
Syntax
=XL.DateToTicks(date)
| Argument | Description |
|---|---|
| date [required] | An expression representing the date and time value |
Examples [download]
Download this spreadsheet with examples and try the function yourself.
| Formula | Description |
|---|---|
| =XL.DateToTicks(TODAY()) | Converts TODAY() to ticks |
| =XL.DateToTicks(NOW()) | Converts NOW() to ticks |
| =XL.DateToTicks(A4) | Converts the date in cell A4 to ticks |
Any questions or suggestions?
