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

	Q	R	S	T
1	Time	DOW	Month	Interval
2	8:17:00 AM	Wed	February	8:00
3	8:37:00 AM	Wed	February	8:30
4	9:07:00 AM	Wed	February	9:00
5	9:34:00 AM	Wed	February	9:30
6	9:56:00 AM	Wed	February	9:30
7	10:27:00 AM	Wed	February	10:00

<tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula T2 =FLOOR([@Time],1/48) <tbody> </tbody>

<tbody>
</tbody>

 

[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