How to you convert the [Interval Start] and [Interval End] data downloaded from the Bandwidth Usage Table? I need to convert the large integers (e.g., 1435425385) into a Date/time that I can recognize (or more precisely, that Excel can recognize).
Also, is there a way to download the data directly to a disk file? Right now the download button opens up a browser page (in I.E. 11) with the data that then has to be saved as a .txt or .csv file.
Downloaded Interval Data
Moderator: Moderators
Re: Downloaded Interval Data
To answer your first question, Linux uses "Epoch" time which is just counting the number of seconds since a certain date (1st January 19something).
There is no built in excel function for converting, but if you google you'll find plenty of examples. Usually just a few divisions and a subtraction.
Good luck
There is no built in excel function for converting, but if you google you'll find plenty of examples. Usually just a few divisions and a subtraction.
Good luck
https://lantisproject.com/downloads/gargoylebuilds for the latest releases
Please be respectful when posting. I do this in my free time on a volunteer basis.
Please be respectful when posting. I do this in my free time on a volunteer basis.