add a number before decimal point if after = 60

[TheLegendTamer]

Hi all,

I have created a column in BI which represents the time, however I need to use it in a declimal format.

Due to this, is there a formula where it would say 

"If the number after the decimal is 60+, add 1 to the number before the decimal point"

This would then be perfect for a time reading format.

Hope that makes sense.

Thanks

[Greg_Deckler]

Can you post a few examples of the input and expected output? 

[TheLegendTamer]

Thank you for the reply.

Yes sure, see attached.

In the 'Hold in Mins' column, I have it saved as a decimal format and in the second pic, it comes up with 1.89 minutes when of course it should say 2 mins 29 secs.

Cheers

[Greg_Deckler]

Take a look at this article and see if it gets you where you need to be:

https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486

[chethan]

@TheLegendTamer change to Average to Sum, Now its Average to Average time will decrease,  so use SUM value 

Regards,

Chetan K