Time sum showing incorrect

[AndVGri]

Hi
I have a measure which is a sum of all time calls per user. But If the that sum is more than 24 hours I have a problem with its displaying. I created a long code for solving that.

Code: Select all

Time Calls = Var allTime = Sum('Persons'[Call Time])
Var prefix = IF(DAY(allTime) > 30 || YEAR(allTime) = 1900; FORMAT(DAY(allTime + 2); "DD") & "d "); "")
RETURN IF(ISBLANK(allTime); BLANK(); prefix & FORMAT(allTime; "HH:mm:ss"))

But is there a way without such coding?
Regards, Andrey.

[MattAllington]

If the total is more than 24 hours, it should give you a date and time I think. If you format the measure as decimal number, it should give you the total decimal days (e.g. 1.25 days). If you times this by 24 it will give you total hours.

[AndVGri]

Thank you, Matt.