Format a duration field when it's already a duration

[PowerBINoob24]

I'm at a loss on whet to do.  I have an app that generates duration data as the duration, e.g., 7:52 is seven hours and 52 minutes.  Exactly what I would expect.  When I bring the data into power bi it comes in as a time/date stamp, which isn't what I want.  I fI transform the column to data, it thorws an error.  Any idea how I can keep the data in the hh:mm format?

[v-echaithra]

Hi @PowerBINoob24 ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
Chaithra.

[v-echaithra · Accepted solution]

Hi @PowerBINoob24 ,

Thank you for posting in Microsoft Community.
I understand that you  want to display as hh:mm duration, not as a time of day or a datetime.
I recommand you to Create a new DAX measure or column to format the duration for display:

Formatted_duration =
VAR TotalMinutes = HOUR([YourColumn]) * 60 + MINUTE([Yourcolumn])
VAR Hours = INT(TotalMinutes / 60)
VAR Minutes = MOD(TotalMinutes, 60)
RETURN
FORMAT(Hours, "00") & ":" & FORMAT(Minutes, "00")

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Regards,
Chaithra.

[v-echaithra]

Hi @PowerBINoob24 ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

Chaithra E.

[PowerBINoob24]

Hi...sorry....no, it has not been resolved.

[v-echaithra]

Hi @PowerBINoob24 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithra E.

[lbendlin]

Your best approach is to ignore that.  Behind the scenes it is turtles datetime all the way down. Once you are ready to render the value on a visual you can format it as needed. But until then - leave it alone.