Forum Discussion

pang22's avatar
pang22
Helper III
2 years ago
Solved

Add hours in Power Query

Hi    How to create a column and add 8 hours to the time in Power Query? 4/26/2024 7:19:04 AM   -->  4/26/2024 3:19:04 PM    
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi pang22 

     

    You can add a custom column with below code. Use #duration(0,8,0,0) to add 8 hours to a datetime value. #duration - PowerQuery M | Microsoft Learn

    [TrackingTime] + #duration(0,8,0,0)

     

    AnalyticsWizard Thanks for the prompt reply. To my knowledge Power Query doesn't have Date.AddHours function.

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi pang22 

 

You can add a custom column with below code. Use #duration(0,8,0,0) to add 8 hours to a datetime value. #duration - PowerQuery M | Microsoft Learn

[TrackingTime] + #duration(0,8,0,0)

 

AnalyticsWizard Thanks for the prompt reply. To my knowledge Power Query doesn't have Date.AddHours function.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!