Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,095
Community Members
 
Community Events
165
Community Groups

Can I change the time formatting settings when exporting a filter to Excel?

Edited

Hey! I'm truing to export my filter with sla's time to Excel. I know that in jira, we can export a filter to an Excel spreadsheet in two ways:

1) Using the "Open in Microsoft Excel" btn

1.JPG

2) Using the "Export" btn

2.JPG

If I using the second way, i got a result what i need, more specifically, the kind of time format that I need: this  3.JPG or like this 4.JPG. I had the time with hours and minutes without "h" or "m", only ":" symbol, but if use the first way, i got it 5.JPG

The situation is such that I need to use the export only through the first path, but I do not know if I can somehow get rid of the letters "h" and "m"? In other words, using the first export method, I need to get the time in the same format as when i using the second method. Has anyone come across something similar or is there a universal solution to my problem? I assume that most likely I will have to configure something directly in Excel itself, but the trouble is that I am practically not familiar with it.

1 answer

How about to do the simple replace in XLS file - Ctrl + H - replace h --> ": ", replace m --> ""

watch video how to replace h,m to : format of time - https://drive.google.com/file/d/18-E1U_u1yTaqva5XL3o8pf9LFCZ7LCZp/view?usp=sharing

time-replace.png

@Serhii Kibitkin_SAASJet_ Thank for your suggestion. I created some function in Excel and it it solved my problem, and in other way, i tried to create macros, how a result it works perfect.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Off-topic

Don't F&*% the planet.

Over the weekend, Atlassian ran a New York Times ad calling on business leaders to join us in committing to a net zero future through the Science-Based Targets Initiative. As part of our gl...

1,182 views 6 39
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you