Remove millisecond decimal from TIME Data Type in Power Query

Power Query
1

So I have this column:
image

and I split the time and date using the custom column command:
image

which looks like it returns the correct result:
image

however, when I select the cell, I can see that the value is keeping the millisecond decimal as well:
image

Can anyone suggest a way to either round to the nearest second (x.000), or just truncate after the period?
I tried using the extract by delimiter option, but when I used the period as delimiter, it removes all the seconds and only the hour and minute remain.

Any insight would be much appreciated.

2

Hi @Schreg,

Give this a go:
Time.From(Time.ToText(DateTime.Time([StartTime]), "hh:mm:ss"))

I hope this is helpful

1 Like
3

This works. Thank you, @Melissa!