Forum Discussion
Time/Duration Value Display
I would try this, the format is text
Measure = VAR Hours = INT([Total Duration]*24) VAR Minutes = RIGHT(FORMAT([Total Duration],"hh:mm"),2) RETURN Hours & ":" & Minutes
try this
Measure = VAR Hours = INT([Total Duration]*24) VAR Minutes = RIGHT(FORMAT([Total Duration],"hh:mm"),2) VAR Separator = IF([Total Duration]=BLANK(),BLANK(),":") RETURN Hours & Separator & Minutes
Microsoft EmployeeHi Anonymous,
IF you want the result to be formatted as "HH:MM", its data type will be forced to text rather than date or numeric. Suppose you have generated a measure to get the total duration, to display total duration based on a 24 hour clock, please try this measure:
Measure =
IF (
VALUE ( LEFT ( [Total duration], 2 ) ) < 24,
[Total duration],
VALUE ( LEFT ( [Total duration], 2 ) )
- INT ( VALUE ( LEFT ( [Total duration], 2 ) ) / 24 )
* 24
& ":"
& RIGHT ( [Total duration], 2 )
)
Regards,
Yuliana Gu
Thank you so much for the guide. When I applied this measure it displayed "12/31/1899" for all of my measures. I tried changing the data type to time, text, general, whole number and none of them seemed to solve the issue. Any ideas?
- Stachu
Community Champion
I would try this, the format is text
Measure = VAR Hours = INT([Total Duration]*24) VAR Minutes = RIGHT(FORMAT([Total Duration],"hh:mm"),2) RETURN Hours & ":" & Minutes
Worked like a charm! Thanks so much!
Stachu The issue I have now is that I get a ":" for values that should be blank. I tried an if statment but cant get it to work properly. any suggestions?
- Stachu
try this
Measure = VAR Hours = INT([Total Duration]*24) VAR Minutes = RIGHT(FORMAT([Total Duration],"hh:mm"),2) VAR Separator = IF([Total Duration]=BLANK(),BLANK(),":") RETURN Hours & Separator & Minutes