Unix Timestamp to Local DateTime
Converts a Unix timestamp (seconds since January 1, 1970) to a human-readable local date and time string.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| UnixTimestamp | number | Yes | Unix timestamp in seconds |
Notes
- Unix timestamp is seconds since epoch (1970-01-01 00:00:00 UTC)
- Converts to local timezone
Examples
=UnixTimestampToLocalDateTime(1704067200)Timestamp from cell
When to Use
- Converting API timestamps
- Working with Unix epoch times
- Data import from systems using Unix time
- Timestamp debugging
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need Excel serial date | Excel DATE functions |
| Need trading date | TradeDate() |
| Need quote timestamp | QuoteDate() |
Common Issues & FAQ
Q: What is a Unix timestamp? A: Seconds since January 1, 1970 00:00:00 UTC.
Q: My timestamp seems wrong? A: Ensure it's in seconds, not milliseconds. Divide by 1000 if needed.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?