excel time stamp not displaying time and date
When exporting an event to excel, the timestamp column only displays the date. the column however holds information of both time and date.
we have to manually create a custom catergory in excel for that column.
1) Select the time stamp column right click the "column letter" and select "Format cells" as shown below.
2)select "Custom" under "Category" and create a new format by typing under the "Type:" option
d/mm/yyyy h:mm:ss AM/PM
and select "OK"
can we separate the date and time category? or find a way on export to display both time and date of timestamp without extra steps.
2
votes
Michael De Haas
shared this idea