I have seconds in a column and converting this to a time HH:mm:ss with the function below. I have noticed this worked perfectly except it never goes over 24 hours (When looking at the data, it definitely should). Also, i am not able to add these together. Is there a way i can change the function below to achieve this?
Got this off youtube at some point, it does work great with the conversion!
Solved! Go to Solution.
For example, I have the rows as shown below and the total does not add up. I am not sure where it is getting the total.
I see. That's a different story. But the problem then lies then most likely with the result [Total Seconds] is yielding and not with [Final Duration]
What you're showing is a matrix visual? What goes into the column Time?
I am adding two measures together (each summing the final duration column on their respective table) to create the value in Time column. Its funny, as it works when the total is under 24 hours.
Can you share the pbix?
Or can you try to show in Time the number of seconds resulting from the addition of those two measures, without the conversion, to see if the value to be converted is actually above 86400 (24 hours)?
I think i see the issue, i am not account for a day in my function. I tried 100485 seconds and it showed 03:54:45. This would be correct as it is 27 hours.
Is there a way to show only hours instead of adding days into function. I would ideally like to have 27:54:45.