How to remove "h" and "m" from custom report in timespent fields? #357
Replies: 3 comments
-
Hi @Lanetolsun, I hope you are referring to worklog report. Already worklog report have settings which can control this behavior. Please look at the formatting options in worklog report settings by clicking on the settings from top right corner. |
Beta Was this translation helpful? Give feedback.
-
Hello, It's a custom report and this field specifically, by default it returns as 1h 30m etc in report. I just don't know what to write to see these hours as numbers. 1h30m -> 1,5 45m -> 0,75 etc. |
Beta Was this translation helpful? Give feedback.
-
Is there still no way to do this simple request? I can't find it by trial and error. |
Beta Was this translation helpful? Give feedback.
-
I wrote a custom report, added a timespent and total timespent field. They appear as 2h, 1h 30m in excel export. I want them to appear as 2 , 1,5 so I can add a formula in Excel.
I know I have to use expressions but couldn't find any example or a reference.
Thanks.
Beta Was this translation helpful? Give feedback.
All reactions