calculate decimal hrs and mins

[rosscortb]

Hello,

I know there is many links on this but seems to be based on having seconds.

I have decimal hrs and seconds but as you can see the sum is incorrect as it should be 92 hrs 15 secs.

Any ideas on how to get this please?

Thanks
Ross

[rosscortb]

@v-kelly-msft I did click the accept as solution yellow button yestereday but looks like you have to click the three dots and do it from there..

[v-kelly-msft]

Hi  @rosscortb ,

Create a column as below:

Column = 
var _wholenumber1=TRUNC('Table'[Column1])
var _wholenumber2=TRUNC('Table'[Column2])
var _totalminutes=('Table'[Column1]-_wholenumber1+'Table'[Column2]-_wholenumber2)*100
Return
TRUNC(_totalminutes/60)+_wholenumber1+_wholenumber2+(_totalminutes-60)/100

And you will see:

If you directly add them up ,it will return as a result of sum up,so you need to separate hours and minutes then add them up.

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mahoneypat · Accepted solution]

This is one way to do this (not directly) with a custom column in the query editor with this formula. Place this in the pop-up box when you add a custom column. The "let" only stores the duration in a variable so that it is not calculated twice.

let dur - #duration(0, Number.RoundDown([Annual Leave],0)+Number.RoundDown([Annual Leave Carryover],0), Number.Round(100*(Number.Mod([Annual Leave],1) + Number.Mod([Annual Leave Carryover],1)),0),0) en Duration.Days(dur)*24 + Duration.Hours(dur)

Best regards

Pat

[rosscortb]

thanks @mahoneypat

thanks for help everyone

[v-kelly-msft]

Hi  @rosscortb ,

So your issue is solved,right?If so,could you pls mark the reply as answered to close it?

I believe more people will benefit from your post.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@rosscortb , is it 91 hours 58 minute + 15 Min then it will 92 hours 13 Min . can you explain

[rosscortb]

@amitchandak sorry yes typo error

91 hrs 58 mins plus 15 mins = 92 hrs 13 mins

[mussaenda]

Hi @rosscortb ,

Then is it possible on your side to round the annual leave decimal hrs then add it to the Carryover column?