Page 1 of 1

Time Stamp on SAP (Time Created)

PostPosted: Fri Jun 08, 2012 11:13 am
by Joeystrike
Hi, I am new to this forum. I wanted to understand how the time stamp works on t-code CJi4

For example, I would like to find the formula that converts 6,964,675,150,000 to whatever time the entry was actually created, let's say 02:05:34 (not sure if those match).
I know that there is a function/t-code that reads and interprets that huge number, but I would like to understand the formula behind it, is it something that is possible to recreate in excel? I would need to create a macro that interprets 6,964,675,150,000 into something usable.

Thanks in advance, and I apologize if the question is too basic :oops: