Convert time to text with format hh:mm:ss

[Anonymous]

Hi

I'm new to PowerBi, and I'm trying to convert a time value (12:50:04) to a integer (125004). For this, I'm doing the following:

a) Converting the time to text

b) Replacing the : for (nothing)

c) Converting the text to integer.

The problem is that in step a), the conversion ignores the seconds, leaving a value like 12:50 and not 12:50:04 as expected.

In one of my tables it works.. but in the others not, not sure why. How can I solve this?

Thanks

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

That is interesting! I received the same results, but what I did was change the time to date time first. Then you could delete first characters. 
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[enakaleah]

This was great, except when I went to convert the date time to text, it changed the time from 9:00AM to 8:59AM. It removed a second from all of the times?