history
Moderator: Qbik Staff
4 posts
• Page 1 of 1
by Pascal » Apr 16 04 7:05 pm
=(x/86400)+25569
In that formula, x, represents the date/time. 86400 is the number of seconds per day, the 25569 is the base for 1 January, 1970.
If you then set the format of that cell to be a date field, with the appropriate time formatting, it should appear correctly.
In that formula, x, represents the date/time. 86400 is the number of seconds per day, the 25569 is the base for 1 January, 1970.
If you then set the format of that cell to be a date field, with the appropriate time formatting, it should appear correctly.
- Pascal
- Qbik Staff
- Posts: 2623
- Joined: Sep 08 03 8:19 pm
- Location: Auckland, New Zealand
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: Majestic-12 [Bot] and 5 guests