Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to convert weird integer date and time values

Hello everybody, I hope someone can help me. I am very new to the whole data analysis world, therefore this is maybe an easily solvable problem. I am trying to use power query in Power Bi to conn...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

No I mean the "Process_Time" from my source data. And the datatype should be Time, something like 07:15:00 instead of 33213.

 

Thank you for your help!

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

You may refer to below to add a custom column.

 

Regards,

Cherie

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    Thanks for the answer, but I am not really sure if that works, because 33213 was just a random picked example number. I dont know if the time to this number is 07:15:00. I was never able to convert this time to a proper time, because ordinal conversion in Python is only used for Dates. Sorry for the confusion.