Forum Discussion
Solved
Time conversion
We use an older phone software that pulls phone data in seconds. So in Excel we have to divide the number by 86,400 and then convert it to the TIME format HH:MM:SS. I have tried to do this in Power B...
Please see this article/video for a great way to handle durations. Keep them as decimal, do your calculations, and then format it however you want at the very end.
Calculate and Format Durations in DAX – Hoosier BI
Pat
Greg_Deckler So this solution did work for me, however, I couldn't get the custom property piece set. I did find another article that showed you can literally type in Excel Format Cell custom in the "Format" box of the measure.
Anyway, thank you sooooo much. This is going to save me a ridiculous amount of time each month!
In her code, it's looking for [Duration] and not finding it. Do I need to create a Duration column? Or would this refer to one of my data columns.
