Calculations of two custom fields in date format

Questions & Answers
,
1

Hi,

I have the two imported custom fields from my jira called “Start time” and " End time". As property:

[Issue].CurrentHierarchyMember.get('End time')

I want to create the measure called “Downtime” and it should to be difference between End time and Start time. I’ve tried functions: DateDiffHours, DateDiffDays but they return me next:

image
image1305×709 38.7 KB

Please assist with this. Maybe I do something wrong.

Thanks

2

This answer helped - Needed to calculate the subtraction between two dates - #2 by oskars.laganovskis -
And now I got this:
image
Could someone advise how can I get the result in a format like this?
image