Re: How to use GsfTimestamp for windows timestamp (relative to 1.1.1601)
Sagi Lowenhardt via gnumeric-list <[email protected]>
| Newsgroups | gmane.comp.gnome.apps.gnumeric |
|---|---|
| Message-ID | <CALM0EdBM5uMrzcPkCE_HtCEAQgmT9r7FbVJ-AUBPLeRb+kJKsA@mail.gmail.com> |
Hi Microsoft Office holds EditTime in minutes starting from 1.1.1601 00:00. So in case someone worked 4 minutes on a document, the time should show 1.1.1601 00:04. But I guess I'll have to find another way to represent this. On Mon, Nov 19, 2018 at 5:52 PM Morten Welinder <[email protected]> wrote: > > As far as my calculation goes, the difference is -11644473600 which > doesn't fit in 32-bit > variable, am I wrong? > > It's hard to know without known what date you are trying to represent. > If you really are trying to represent a date back in year 1601 then > you are out of luck. If, on the other hand, you are trying to > represent a date after 1970 then you should have no problem. > > Morten > _______________________________________________ gnumeric-list mailing list [email protected] https://mail.gnome.org/mailman/listinfo/gnumeric-list