Sum Hours against a Constant

[DLROLLINGS]

Hi,

New to Power Bi, bought myself a nice book to help but this is locked in my office and I am not currently able to get there so working blind with it. So far so good (even if I do say so myself).

Have a problem with multiplying a number against a set constant time. I am using the following:

Account Review Time = Hour([Accounts Checked]*(time(0,03,0)))+trunc(minute([Accounts Checked]*time(0,03,0))/60)&":"&mod(MINUTE([Accounts Checked]*time(0,03,0)),60)&":00"

This returns me a value of 0:42:00

Does the same in excel so I know the maths is correct but in excel I can change the format of the cell to [hh]:mm:ss and that gives me hours over 24. For reference, by coincidence the number of hours is a multiple of 24.

Any help much appreciated.

[v-diye-msft]

Hi @DLROLLINGS 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[Greg_Deckler]

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

[amitchandak]

@DLROLLINGS ,

Refer if this can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...

[DLROLLINGS]

Thanks for this, trying to apply this to my formula but unsuccesfully.....very confused 😕