Metadata Date/Time Format

Is there anyway to change the exported XLS format of the date and time from the metadata? The format I am currently seeing in exported files is the following: 2021-01-21T14:31:28.979+01:00

This is difficult to read and organize. Would appreciate any insight!

HI @zradanovic
When in Excel, you could create a column and insert the following =(LEFT(RIGHT(A2,18),5))

Remember to change A2 to correspond to the first cell with the time information you need to convert. You can then drag this down to populate the rest of the form.

HintWhen you subtract two-time points from this conversion, multiply what you get by 1440 to get the difference in minutes. This is because the difference is always provided in days and you thus need to multiply it by (24*60) to get minutes.


1 Like