Forum Discussion
Solved
How to remove seconds from time column?
How can I remove seconds from this time column? any help is greatly appreciated.
Hello imontoya14 ,
Here is an option:
=DateTime.From(Number.RoundDown(Number.From(DateTime.From([Time]))*(24*60/1))/(24*60/1))Also here is an article with explanation and other rounding options: How to categorize and group data in time intervals with Power Query .
Did I answer your question? Mark my post as a solution!
Hi there, thank you for your response. That worked but it looks like it created another problem. Upon creating the new column and completing the changes above. It switched my AMs to PMs and vise versa. How can I fix this so the format (AM/PM) does not change.
Your post helped me, to resolve the AM and PM issue, make sure you use capital HH like so
DateTime.From ( DateTime.ToText( [DateColumn] , "yyyy-MM-dd HH:mm") )