Add values of column HH:MM:SS

[Anonymous]

I have a column which is in format HH:MM:SS of type Text.

When i try to convert it to time it gets changed to like from 00:00:13 to 12:00:13  and when i change it

to whole number it gives an error .

Basically i want to add values of HH:MM:SS and plot it against date in bar chart.

Let me know how can i do it.

Thanks!

[Greg_Deckler]

@Anonymous Use Duration to Seconds and Chelsie Eiden's Duration:

Duration to Seconds Converter - Microsoft Power BI Community

Chelsie Eiden's Duration - Microsoft Power BI Community

[Anonymous]

Your formula is not working giving me error . My seconds is in decimal like 180.003 . Do i need to remove

decimals so that the formula should work?

[Anonymous]

Hi @Anonymous 

How did you get 180.003 by that code? Your text time is HH:MM:SS. What do your hour, minute or second look like, whole number or decimal number? Does it look like 00:03:0.003?

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Anonymous Leave your column as Text and use Duration to Seconds to convert it to seconds. You can then use Chelsie Eiden's Duration to return a numerical value that displays as HH:MM:SS. If you can provide some sample data as text I can be more specific.

[amitchandak]

@Anonymous , I doubt power bi y axis support time. You can use time in second or minute

example

left([col])*3600 + mid([column],3,2)*60 + right([column],2)*1

and use that in visual y axis