cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sevendust
Level: Powered On

Adding hours to date.

Hello all,

 

What I am trying to accomplish is a text box that shows a new date stemming from hours added onto the date selected.  In excel I was using:

=IF(D81="","",IF(AND(ISNUMBER(D81),F81=""),$C$77+(D81/24),IF(ISNUMBER(F81),$C$77+(F81/24))))

 

Thanks in advance for the assistance.

 

 

Date+Hours.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Adding hours to date.

Hi @Sevendust,

Could you please share a bit more about your scenario?

Do you want the End Date/Time to be equal to selected date (e.g. '10/25/2018 18:30 ') plus actual hours?

If you want the End Date/Time field to be equal to selected date (e.g. '10/25/2018 18:30 ') plus actual hours within your Edit form, I think the DateAdd function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:14.JPG

Set the Default property of the End Date Data card to following formula:

If(
IsBlank(Actual_x0020_Hours_DataCard2.Update),
Start_x0020_Date_DataCard2.Update,
DateAdd(Start_x0020_Date_DataCard2.Update,Actual_x0020_Hours_DataCard2.Update,Hours)
)

Note: The Start_x0020_Date_DataCard2 represents the Start Date Data card control, the Actual_x0020_Hours_DataCard2 represents the Actual Hours Data card control.

The GIF screenshot as below:Test1.gif

 

 

More details about the DateAdd function in PowerApps, please check the following article:

DateAdd function

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
HadynM
Level 8

Re: Adding hours to date.

Hi @Sevendust

The DateAdd function sounds like what you're after:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-dateadd-datediff

Use it like:

DateAdd(StartDate,Value(ActualHours),Hours)

Hope that helps

Hadyn

Community Support Team
Community Support Team

Re: Adding hours to date.

Hi @Sevendust,

Could you please share a bit more about your scenario?

Do you want the End Date/Time to be equal to selected date (e.g. '10/25/2018 18:30 ') plus actual hours?

If you want the End Date/Time field to be equal to selected date (e.g. '10/25/2018 18:30 ') plus actual hours within your Edit form, I think the DateAdd function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:14.JPG

Set the Default property of the End Date Data card to following formula:

If(
IsBlank(Actual_x0020_Hours_DataCard2.Update),
Start_x0020_Date_DataCard2.Update,
DateAdd(Start_x0020_Date_DataCard2.Update,Actual_x0020_Hours_DataCard2.Update,Hours)
)

Note: The Start_x0020_Date_DataCard2 represents the Start Date Data card control, the Actual_x0020_Hours_DataCard2 represents the Actual Hours Data card control.

The GIF screenshot as below:Test1.gif

 

 

More details about the DateAdd function in PowerApps, please check the following article:

DateAdd function

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Sevendust
Level: Powered On

Re: Adding hours to date.

You are AWESOME!!!! Much thanks!!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 90 members 5,521 guests
Please welcome our newest community members: