Hey there!
I am trying to pull the amount of time a case stays as a certain status in Jira, but I am unable to pivot the format in which Jira exports time.
Is there a way to convert the following format into just minutes?
1 h, 48 m, 30 s
I would like the value above to become 108.5 so I can create a pivot table.
I am just manually converting everything into minutes at the moment, so any advice to streamline this process would be much appreciated.
Thanks!
I am trying to pull the amount of time a case stays as a certain status in Jira, but I am unable to pivot the format in which Jira exports time.
Is there a way to convert the following format into just minutes?
1 h, 48 m, 30 s
I would like the value above to become 108.5 so I can create a pivot table.
I am just manually converting everything into minutes at the moment, so any advice to streamline this process would be much appreciated.
Thanks!