Forum Discussion
Solved
Powerapps form - formula to calculate minutes between two Date/Time columns
Hi,
I have two Date/Time Columns
Off time - Off Time_DataCard2
Out time -Out Time_DataCard2
and I have a calculated field
Delay Minute -datacardValue82
I would like to calculate the difference in minutes between the two entered date/times and display in Text of Delay Minutes.
I have tried and I just can't seem to write the correct formula.
Any help on this formula is greatly appreciated!
Ren
RenPNW You can use formula like below to get the minutes between two date picker controls:
DateDiff( DateTimeValue(DataCardValue33.Selected.Value), DateTimeValue(DataCardValue34.Selected.Value), Minutes )References:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
1 Reply
RenPNW You can use formula like below to get the minutes between two date picker controls:
DateDiff( DateTimeValue(DataCardValue33.Selected.Value), DateTimeValue(DataCardValue34.Selected.Value), Minutes )References:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.