Get Time from DateTime field

Hi @Thankyouverymuc ,

Here a solution for a calculated column as described in this blog post as well:
https://www.tackytech.blog/how-to-crack-the-mystery-of-the-mighty-dax/#22_How_to_retrieve_the_time_from_a_datetime_column

We start by duplicating the datetime column:

--> Right click on a column in your table and select new column:

--> duplicate the column by referencing the datetime column:

Then, just change the format to Time (just like @Syk  suggested in Power Query):

The result:

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

Sorry to jump in on this forum but noticed there wasn't a DAX solution on here.  If you're looking for a DAX solution, you can extract the Time from a DateTime column by doing the following:

1.  Click on new Calculated Column

2.  Time = FORMAT ( 'TableName'[DateTimeColumnName] , "hh:mm:ss" )

3. Convert the new Time column from Text to Time.

Hope this helps.

Theo