Gargoyle Forum

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.

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

OK, thanks.