cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

DECIMAL TIM TO HOUR TIME SUM

Good Day GUYS

I am in need of help relating to some coding

I am using the following formula that converts Decimal time To Hour Time:

```TicketTime To Hours =
// Duration formatting
// * @konstatinos 1/25/2016
// * Given a number of seconds, returns a format of "hh:mm:ss"
//
VAR Duration = [JOB_TIME]
// There are 3,600 seconds in an hour
VAR Hours =
INT ( Duration / 3600)
// There are 60 seconds in a minute
VAR Minutes =
INT ( MOD( Duration - ( Hours * 3600 ),3600 ) / 60)
// Remaining seconds are the remainder of the seconds divided by 60 after subtracting out the hours
VAR Seconds =
ROUNDUP(MOD ( MOD( Duration - ( Hours * 3600 ),3600 ), 60 ),0) // We round up here to get a whole number
// These intermediate variables ensure that we have leading zero's concatenated onto single digits
VAR H =
IF ( LEN ( Hours ) = 1,
CONCATENATE ( "0", Hours ),
CONCATENATE ( "", Hours )
)
VAR M =
IF (
LEN ( Minutes ) = 1,
CONCATENATE ( "0", Minutes ),
CONCATENATE ( "", Minutes )
)
VAR S =
IF (
LEN ( Seconds ) = 1,
CONCATENATE ( "0", Seconds ),
CONCATENATE ( "", Seconds )
)
// Now return hours, minutes and seconds with leading zeros in the proper format "hh:mm:ss"
RETURN
CONCATENATE (
H,
CONCATENATE ( ":", CONCATENATE ( M, CONCATENATE ( ":", S ) ) )
)```

So it is converting the time to the correct time now, the only issue I have is that it now changes to TEXT and I cannot SUM the time at all

Do I need to use a Different Formula? I need the below to be summed and not split as it is
Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

Re: DECIMAL TIM TO HOUR TIME SUM

No, unfortunately Power BI does not support aggregation in a "duration" format. Been an issue since the beginning. You need to do your aggregation and then convert to "duration" format.

Proud to be a Datanaut!