Power Platform Community Forum Thread Details

Hi Team,

I am facing a challenge where I am using in gallery dropdown to select time and based on time want to get the difference in hour and minutes in HH:MM format. on the current I am using the code as I am sharing but getting wrong result also sharing the snapshot. If someone did this kind of functionality please do let me know.

DateDiff(
 DateValue("01/01/2024") + Time(
 Value(LookUp(colactivrreport,RID=ThisItem.RID+1).DDhour),
 Value(LookUp(colactivrreport,RID=ThisItem.RID+1).DDmin),
 0
 ),
 DateValue("01/01/2024") + Time(
 Value(LookUp(colactivrreport,RID=ThisItem.RID).DDhour),
 Value(LookUp(colactivrreport,RID=ThisItem.RID).DDmin), 
 0
 ),
 TimeUnit.Hours
) & ":" & Mod(
 DateDiff(
 Startdate.SelectedDate + Time(
 Value(LookUp(colactivrreport,RID=ThisItem.RID+1).DDhour),
 Value(LookUp(colactivrreport,RID=ThisItem.RID+1).DDmin),
 0
 ),
 Startdate.SelectedDate + Time(
 Value(LookUp(colactivrreport,RID=ThisItem.RID).DDhour),
 Value(LookUp(colactivrreport,RID=ThisItem.RID).DDmin),
 0
 ),
 TimeUnit.Minutes
 ),
 60
)

In this code date will be the default save for all and date will visible false name with Start date and dropdown will as DDhour & DDmin.

Regards,

Vk_Mohit