Forum Discussion

weeksd's avatar
weeksd
Frequent Visitor
4 years ago
Solved

Time format greater than 24 hours

Hi all I am working on a Power BI report  in which I am dealing with time values. My issue is that when I sum up a column and then try to display the total in PBI it truncates the time value to 24 ho...
Need Help
  • PC2790's avatar
    PC2790
    4 years ago

    Hey weeksd ,

     

    Can you once try this:

     

    Required = 
var _sum = sum(TimeTable[flow_time])
VAR hours =  INT( _sum * 24 )
VAR Minutes = MINUTE(_sum)
VAR Seconds = SECOND(_sum)
RETURN
Hours & ":" & Minutes & ":" & Seconds

     

     

PC2790's avatar
PC2790
Icon for Community Champion rankCommunity Champion
4 years ago

Hey weeksd ,

 

Can you once try this:

 

Required = 
var _sum = sum(TimeTable[flow_time])
VAR hours =  INT( _sum * 24 )
VAR Minutes = MINUTE(_sum)
VAR Seconds = SECOND(_sum)
RETURN
Hours & ":" & Minutes & ":" & Seconds

 

 

  • YcnanPowerBI's avatar
    YcnanPowerBI
    Icon for Helper II rankHelper II
    3 years ago

    I just ran across this same issue and was able to use your solution! Thank you!

  • Hithahrk's avatar
    Hithahrk
    Regular Visitor
    2 years ago

    Hello, I was having the same problem and your solution partially solved it. 

    I have a column with some negative duration value (due to a difference between worked time and planned working time) and when these negative value convert to hh:mm:ss the have 1 hour added to the result

    Ex : instead of obtaining "-0:55:0" I obtain "-1:55:0"

     

    Is there something to do ?

    I tried to an if statement to add one hour to the hour Var if a value is negative but I don't really understand how to write with the variable