Forum Discussion

matihernandez94's avatar
matihernandez94
Frequent Visitor
5 years ago
Solved

set hours

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...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    matihernandez94 

    Add the following calculated column to your table

     

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

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

matihernandez94 

Add the following calculated column to your table

 

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