Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Exporting times are not showing AM or PM

Damian Martin April 28, 2023

When exporting times in a CSV file they are shown on in helpdesk as 24 hour but the export outputs the time in 12 hour format but does not differentiate between AM and PM. For example, a field showing 13:30 and another field showing 1:30 AM the export shows 1:30 for both.

Its critical for reporting to compare the difference between 2 dates and times

1 answer

0 votes
Dan Breyen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 3, 2023

Damian, when you look at your CSV file?  What do you see?  I'm on the cloud and when I export an issues list to a CSV file, the times show up with AM/PM in the actual CSV file, and then they are imported into Excel as 24 hr times.  If the times aren't differentiated in your CSV file, would it be possible to give an example? Or, you might want to open a support ticket @ so they could look deeper into this for you.  Hope that helps.

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events