How to convert excel times back to MM:SS on power BI and also allow the model to average the times?

[Sean29]

I currently have a small data set of running times, which on excel I have converted minutes and seconds using =TIME(0,Min,Sec) etc. and set custom time to represent MM:SS. When I convert this to Power BI this it is converted to date hierarchy. How do create measure to replicate excel times back to MM:SS on power BI and also allow the model to average the times?

Currnet example

Excel                     Power Bi

Min Sec Time        Date hiearchy = Run time 

9      23   9:23                                    9:23

[v-prasare]

Hi @Sean29, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@Sean29, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

@Sean29, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

@lbendlin , Thanks for your promt response.

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[lbendlin · Accepted solution]

You can still do math on these times. The math will become awkward if you go over 24 hours.

Remember - Dates are the integer part, hours, minutes and seconds are the fractional part.  24 /1440 / 86400

Disable Auto Date/Time if you don't want the hierarchy