09-11-2007 11:02 PM - edited 03-14-2019 11:29 PM
Hi,
I was asked to get the call details of a certain user then do it thru sql query on our pubs. I did get what I want...but the problem is, the date/time is not correct.
i found some formula conversion:
*convert from date/time:=(A2-DATE(1970,1,1))*86400
*convert to date/time==D2/86400+DATE(1970,1,1)
which worked but still the time is not correct...
Can anyone help me?
tnx
Solved! Go to Solution.
09-12-2007 11:24 PM
09-11-2007 11:37 PM
You should remember that timestamp is GMT time. So, after conversion you have to add proper timezone.
For example in Poland summer time is +2h and winter time is +1h.
--
regards,
pk
09-11-2007 11:55 PM
Thanks for replying.
sorry Im just a newbie. Can you pls. answer that in details?
like where to do that? in excel? how?
tnx
09-12-2007 12:27 AM
You can use web tool: http://www.4webhelp.net/us/timestamp.php
09-12-2007 04:28 PM
Thank you very much pklos. your such a great help!
How about when in excel? (cause I got a lot of time to convert) Do anyone know of a formula how to add hours when in excel?
ex:8/1/07 12:01 AM --->8/1/07 8:01am
tia
09-12-2007 05:09 PM
Good news pklos,
I already got it.
here's the formula: =D3/86400+DATE(1970,1,1)+8/24
*1/24 - plus 1 hour
*2/24 - plus 2 hours
*etc....
Hope it can help others too...
Thanks
09-12-2007 11:24 PM
Please rate "such a great help!"
;)
--
regards,
pk
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: