Ask Your Question
0

Excel - how to show date & time correctly?

asked 2020-01-25 18:23:53 +0000

Robnw gravatar image

I'm using a CSV export, but can't get the dates & time to display correctly. Is there an easy solution that I'm missing?

I assume this is because the two programs use two different date formats, but I can't seem to deduce an easy way to convert from one to the other.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
0

answered 2020-01-25 18:51:29 +0000

Guy Harris gravatar image

If you're exporting CSV from Wireshark (File > Export Packet Dissections > As CSV...), rather than using -T fields etc. in TShark, then it's exporting the columns of the packet summary; if you specify the time format as "date and time of day" (View > Time Display Format > Date and Time of Day), then the CSV export will show the date and time as YYYY-MM-DD HH:MM:SS.SSSSSS.

According to this Stack Overflow question's current topmost answer:

For second accuracy, yyyy-MM-dd HH:mm:ss should do the trick.

I believe Excel is not very good with fractions of a second (loses them when interacting with COM object IIRC).

which suggests that the ".SSSSSS" part of that might be an issue, but that YYYY-MM-DD HH:MM:SS, at least, should work.

edit flag offensive delete link more

Comments

Thank you.

Robnw gravatar imageRobnw ( 2020-01-26 01:53:50 +0000 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools

1 follower

Stats

Asked: 2020-01-25 18:23:53 +0000

Seen: 39 times

Last updated: Jan 25