|
UTC time
Hi,
You're probably looking at UTC time, which can be a total pain to work out, it is based on the number of seconds elapsed since the start (0) date. Once you have it figured, most DB have built in functions to handle it, or you can do it in Excel manually. Start date is usually around 1972, but check for your particular version. It's hard to project dates forward too, because it gets adjusted twice a year if required by a tiny amount to keep it accurate.
Good Luck,
Jaz
|