Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Changing decimal number into Duration

I have a table with a Start and Finish time I have created a calculated column which subtracts Finish time from start time to give me a duration. The issue I'm having is the format in which the Durat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi mussaenda, 

 

Thanks for getting back to me! Unfortuantly that didn't work! I got an error where some of the Finished dates return blanks. 

 

 

I tried to use the Try  Otherwise function. But this just returned the "otherwise" value for all rows.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous  - It looks like you are getting back a value that is essentially the decimal portion of a day (24 hours). In DAX, you could get that duration in seconds using the following:

 

Column = ([Finished] - [Started]) * 1. * 24 * 60 * 60

So, Finished - Started and you multiply by 1. to get a decimal value. You then multiply this by 24 to get the number of hours, 60 to get the number of minutes and then 60 again to get the number of seconds.