add minutes to Time/Date column

Question

Hi,I am still looking for help on a formula that will allow me to add 45 minutes to a Time/Date column on a powerapps form.&nbsp; The user selects the date and time and I need to have 45 minutes added to that time.&nbsp;I have a calculated column but I think I will replace that with a text label, but either way can't figure out how to add the time.&nbsp;The time/date column-&nbsp;Diversion ON_DataCard2Calculated column -&nbsp;Diversion Comm Time_DataCard1&nbsp;Thanks for the help!&nbsp;Ren&nbsp;

rob_elliott · Answer

RenPNW&nbsp;use&nbsp;DateAdd(txtNow.Text, 45 ,TimeUnit.Minutes) changing my txtNow.Text to whatever your field is called:&nbsp;&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User.Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

renpnw · Answer

Thanks Rob but no matter what I try I can't seem to get the formula to work.
here is the formula that I am using:
DateAdd('Diversion ON_DataCard2',45,TimeUnit.Minutes)
the Date and Time are user inputs and I tried the formula on a calculated column and a text label and I can't get either to accept the formula. I am not that experienced with Sharepoint Power app formulas, it is probably something that is an easy fix but I cannot figure it out.

Ren

rob_elliott · Answer

RenPNW&nbsp;Don't add it to the data card, it needs to be added to the value field inside the data card:&nbsp;&nbsp;RobLos GallardosMicrosoft Power Automate Community Super User.Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Forum Discussion

add minutes to Time/Date column

Share

Resources