web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / DateAdd/Timeadd formul...
Power Apps
Answered

DateAdd/Timeadd formula to add hours to existing Date/Time value

(0) ShareShare
ReportReport
Posted on by 83

Hi,

I am trying to find a formula to add hours to a date/time value field - for ex. I would like to add 2 hours from now as deadline for a job to be completed. I could see Dataadd function, but this one looks like add only years, months or days, not hours or minutes.

My jobs are due to finish in hours or minutes, not days 🙂

Is there any chance to achieve this?

 

Thank you!

Categories:
I have the same question (0)
  • Verified answer
    AndyPennell Profile Picture
    Microsoft Employee on at

    Date/time is measured in days, so for example the formula

     

    Now() + 1

     

    is tomorrow. Or

     

    Now() + 0.5 is 12 hours in the future.

     

    So to add 1 hour, use

     

    Now() + 1/24

     

    for example. To add a minute, use

     

    Now() + 1/(24*60)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 505

#2
WarrenBelz Profile Picture

WarrenBelz 502 Most Valuable Professional

#3
Haque Profile Picture

Haque 324

Last 30 days Overall leaderboard