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
serpiva64
Solution Sage
Solution SageHi,
you can create a calculated column this way
Column = var currsec ='Table'[Seconds]
VAR hours =ROUNDDOWN(DIVIDE('Table'[Seconds],3600),0)
var minutes =ROUNDDOWN(divide('Table'[Seconds]-hours*3600,60),0)
var seconds = 'Table'[Seconds]-hours*3600-minutes*60
RETURN
time(hours,minutes, seconds)
and you get your result
as you see there is a problem if time is over a day. if that is your problem need some more steps.
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Sorry, but we do reports that calculate the entire month so the numbers often go over 100 hours so yes, that is over a day
