Excel Date Time Examples

To display timestamps exported from Noodle to csv files in Microsoft Excel, format the column as custom with this pattern;

yyyy-mm-dd hh:mm:ss.000

To show just the date one of these formulae can be used;


To show just the time one of these formulae can be used;


Like all formula the above examples can be applied to whole columns by copy pasting, dragging, or double clicking.

Note that Microsoft Excel does not respect original formatting so any save (without any edit) can convert a timestamp into a number representing seconds since epoch.