set hours

[matihernandez94]

hi everyone, 

i need to set the hours of dates, for example if the day is 21/05/2021 05:35:20 i want change to 21/05/2021 10:00:00. And that for a lot of dates, always with the 10:00:00.

Hola a todos necesito cambiar el horario de las fechas en mis bases de datos, en las cuales si no estan dentro del horario laboral que es de (10:00:00 a17:00:00) cambie la hora a las 10:00:00. Ya que nose como modificar este campo.

Por ejemplo si es 21/05/2021 05:35:20 quiero cambiar ese campo al siguiente 21/05/2021 10:00:00.

[matihernandez94]

thanks , 

but in the editor of power query the funcion "int"  is not available

how i can do that ? 😞 

[Fowmy]

@matihernandez94 

I thought you wanted a solution as a Calculated Column in the model. No issue, Please use the add custom column in Power Query and use the following code.

[Fowmy · Accepted solution]

@matihernandez94 

Add the following calculated column to your table

New Date and Time = INT(Table[Date]) + TIME(10,0,0)

[matihernandez94]

Thanks bro !