SOLVED

Powerapps form - formula to calculate minutes between two Date/Time columns

Copper Contributor

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

 

1 Reply
best response confirmed by RenPNW (Copper Contributor)
Solution

@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:

  1. Power Apps DateDiff - Hours and Minutes 
  2. Power Apps DateAdd, DateDiff, and TimeZoneOffset functions 

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 best response

Accepted Solutions
best response confirmed by RenPNW (Copper Contributor)
Solution

@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:

  1. Power Apps DateDiff - Hours and Minutes 
  2. Power Apps DateAdd, DateDiff, and TimeZoneOffset functions 

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.

View solution in original post