I 2 columns in Excel with times, I need to round one column down to the nearest 5 minutes and the other one up to the nearest 5 minutes.
In Excel I’d use these formulas:
=FLOOR(A1,"00:05")
=CEILING(A1,"00:05")
I can’t find the equivalent in Power Query, the closest I get is Time.StartOfHour, what I need is the equivalent of Time.StartOf5Minutes and Time.EndOf5Minutes!