Little friday rant...

I had to export to Excel a Jira timesheet where times are noted in the format "0.0h" so, for example, 2 and half hours would be 2.5h

That's great visually but its useless from a data manipulation perspective.

There is also an option to export the report to a csv and I thought "oh, I'm sure this option would provide a better format that I can actually use"

And that was almost true.... the CSV data doesn't have the "h" in it so all entries are in fact considered numbers BUT for some stupid reason if the original entry was 2.5h, it's exported to the CSV as 25 which doesn't really help me either...

WIll need to use some excel magic before I can actually use any of this data