Power Query rounding

[Weazel]

In excel, when I have to round time to the nearest 30 minutes I can use =FLOOR([@Time],1/48), pretty straight forward.

I haven't been able to sort out the correct power query function though and I'm currently having to take care of it in the table.

Any assistance would be greatly appreciated

Unknown[TABLE="class: grid, width: 400"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH][/TH]
[TH]Q[/TH]
[TH]R[/TH]
[TH]S[/TH]
[TH]T[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Time[/TD]
[TD]DOW[/TD]
[TD]Month[/TD]
[TD]Interval[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]8:17:00 AM[/TD]
[TD]Wed[/TD]
[TD]February[/TD]
[TD="align: right"]8:00[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]8:37:00 AM[/TD]
[TD]Wed[/TD]
[TD]February[/TD]
[TD="align: right"]8:30[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]9:07:00 AM[/TD]
[TD]Wed[/TD]
[TD]February[/TD]
[TD="align: right"]9:00[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]9:34:00 AM[/TD]
[TD]Wed[/TD]
[TD]February[/TD]
[TD="align: right"]9:30[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]9:56:00 AM[/TD]
[TD]Wed[/TD]
[TD]February[/TD]
[TD="align: right"]9:30[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]10:27:00 AM[/TD]
[TD]Wed[/TD]
[TD]February[/TD]
[TD="align: right"]10:00[/TD]
[/TR]
</tbody>[/TABLE]

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]T2[/TH]
[TD="align: left"]=FLOOR([@Time],1/48)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[MarcelBeug]

You can add a custom column with formula:

= Time.From(Number.IntegerDivide(48*Number.From([Time]),1)/48)

 

[Weazel]

Thanks Marcel, its working great, I appreciate it