Unanswered

Displaying minutes elapsed between two date time fields in text box

(0) Share

Report

Posted on by IanSL

Set(varStartDateTime, DateAdd(CleanStartDate.SelectedDate, Time(Value(CleanStartHour.Selected.Value), Value(CleanStartMinute.Selected.Value), 0)));

Set(varEndDateTime, DateAdd(CleanEndDate.SelectedDate, Time(Value(CleanEndHour.Selected.Value), Value(CleanEndMinute.Selected.Value), 0)));

For some reason this is not working,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @IanSL ,

Try this format

With( { _Days: DateDiff( CleanStartDate.SelectedDate + Time( Value(CleanStartHour.Selected.Value), Value(CleanStartMinute.Selected.Value), 0 ), CleanEndDate.SelectedDate + Time( Value(CleanEndHour.Selected.Value), Value(CleanEndMinute.Selected.Value), 0 ), TimeUnit.Minutes ) / 1440 }, With( { _Hours: Mod( _Days, RoundDown( _Days, 0 ) ) * 24 }, "Days: " & RoundDown( _Days, 0 ) & " Hours: " & RoundDown( _Hours, 0 ) & " Minutes: " & Mod( _Hours, RoundDown( _Hours, 0 ) ) * 60 ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
IanSL 6 on at

Like (0)

Report

Was this reply helpful? Yes No
zuurg 535 Super User 2024 Season 1 on at

Like (1)

Report

If both dates & times are already properly formatted DateTime elements (like Now()) You can simply use DateDiff(datetime1,datetime2,TimeUnit.Minutes)

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
@IanSL ,

That was a division by zero issue - here is a different approach - this one should work

With( { _Calc: DateDiff( CleanStartDate.SelectedDate + Time( Value(CleanStartHour.Selected.Value), Value(CleanStartMinute.Selected.Value), 0 ), CleanEndDate.SelectedDate + Time( Value(CleanEndHour.Selected.Value), Value(CleanEndMinute.Selected.Value), 0 ), TimeUnit.Minutes ) }, With( { _Days: RoundDown( _Calc / 1440, 0 ), _DayMins: Mod( _Calc, 1440 ) }, With( { _Hours: RoundDown( _DayMins / 60, 0 ), _Minutes: Mod( _DayMins, 60 ) }, _Days & " Days " & _Hours & " Hours " & _Minutes & " Minutes" ) ) )

If you simply want the minutes, then just use this

DateDiff( CleanStartDate.SelectedDate + Time( Value(CleanStartHour.Selected.Value), Value(CleanStartMinute.Selected.Value), 0 ), CleanEndDate.SelectedDate + Time( Value(CleanEndHour.Selected.Value), Value(CleanEndMinute.Selected.Value), 0 ), TimeUnit.Minutes )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
IanSL 6 on at

Like (0)

Report

Perfect! Thank you so much!

Was this reply helpful? Yes No