Forum Discussion
How to remove seconds from time column?
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!
Hey imontoya14 ,
add a new column with the DateTime.ToText function. With the second format parameter you can format it without seconds:
DateTime.ToText([DateTime], "yyyy/MM/dd hh:mm")
Afterwards change the date type again to "Date/Time". Then you should have the values without seconds.
If you want to skip one step you can also directly convert it to date/time in the same step:
DateTime.FromText( DateTime.ToText( [DateTime], "yyyy/MM/dd hh:mm" ) )
Let me know if that works for you. If you need any help please let me know.
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.
any help is appreciated. Thank you.
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") )