Forum Discussion

RenPNW's avatar
RenPNW
Copper Contributor
Apr 14, 2024
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 ...
microsoft lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Apr 15, 2024

    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.

ganeshsanap's avatar
ganeshsanap
MVP
Apr 15, 2024

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.

Resources